sql server 数据库
关注
分享
扫一扫
文章平均质量分 88
weixin_40304882
这个作者很懒，什么都没留下…
展开
-
中级sql查询语句的几个小例子
所用到的数据库表在前一篇博客中体现，在此不再赘述。Using the university schema that you have write the following queries. In some cases you might need to insert extra data to show the effect of a particular feature.Recommendat...原创 2018-06-12 20:24:34 · 676 阅读 · 1 评论 -
高级sql查询的几个小例子
数据库表与之前所描述的数据库表相同，在此不再赘述。Using the university schema that you have write the following queries. In some cases you might need to insert extra data to show the effect of a particular feature.1. Insert e...原创 2018-07-06 21:19:21 · 903 阅读 · 0 评论 -
sql server 中单表查询、多表查询、聚合查询、多表查询、子查询和几何查询的几个小例题
DEPT (DEPTNO INT, DNAME VARCHAR(14),LOC VARCHAR(13));EMP (EMPNO INT,ENAME VARCHAR(10), JOB VARCHAR(9), MGR INT, HIREDATE DATE, SAL FLOAT, COMM FLOAT, DEPTNO INT);BONUS (ENAME VARCHAR(10), JO...原创 2018-05-30 09:47:28 · 2327 阅读 · 1 评论 -
sql server 多表连接
sql server数据库多表连接查询语句，用到的数据库表如下：1.Find the ID, names of all the instructors from departments whosename contain character '门'select ID,namefrom instructor left join department on instructor.dept_name=...原创 2018-05-30 16:28:00 · 5865 阅读 · 1 评论