sql面试题
运气可以啊
这个作者很懒,什么都没留下…
展开
-
sql中having与where的用法区别
1.where与group byselect deptno from emp where sal>100 group by deptno; 正确select deptno from emp group by deptno where sal>100; 错误2.having 与 group byselect deptno from emp group by deptn...原创 2019-11-20 10:54:47 · 319 阅读 · 0 评论 -
sql题
1.查询表中男女各多少人?select s_sex,count(*) from student where s_sex in('男','女') group by s_sex原创 2019-08-08 22:32:08 · 92 阅读 · 0 评论