QQ图片20160601230903.png (14.64 KB, 下载次数: 23)
表内容
yesnowoshiqiang 发表于 2016-6-2 00:55
select * from 表名 where not (job='销售员') and sal>5000 order by sal;##默认即使升序,倒序的话加个de ...
yesnowoshiqiang 发表于 2016-6-2 00:55
select * from 表名 where not (job='销售员') and sal>5000 order by sal;##默认即使升序,倒序的话加个de ...
li6232876 发表于 2016-6-2 06:55
正确的是这样的:
SELECT job,SUM(sal) FROM emp where job != '销售员' GROUP BY job HAVING SUM(sal)>5 ...
li6232876 发表于 2016-6-2 06:55
正确的是这样的:
SELECT job,SUM(sal) FROM emp where job != '销售员' GROUP BY job HAVING SUM(sal)>5 ...
li6232876 发表于 2016-6-2 06:55
正确的是这样的:
SELECT job,SUM(sal) FROM emp where job != '销售员' GROUP BY job HAVING SUM(sal)>5 ...
欢迎光临 黑马程序员技术交流社区 (http://bbs.itheima.com/) | 黑马程序员IT技术论坛 X3.2 |