Classes More Than 5 Students
来源:互联网 发布:lol网络关注 编辑:程序博客网 时间:2024/06/10 22:26
代码:
select class from a GROUP BY class HAVING COUNT(*)>=5
这样依旧会报错的,注意红色框里面,学生里是不可以重复的。
正确代码:
select a.class FROM (
select DISTINCT student ,class ,COUNT(*) from a GROUP BY class,student ) a GROUP BY a.class
HAVING COUNT(*)>=5
要防止学生重复
leetcode 提交运行截图
leetcode 代码:
select a.class FROM (
select DISTINCT student ,class ,COUNT(*) from courses GROUP BY class,student ) a GROUP BY a.class
HAVING COUNT(*)>=5
阅读全文
1 0
- Classes More Than 5 Students
- 596. Classes More Than 5 Students
- [leetcode]596. Classes More Than 5 Students
- Leetcode596. Classes More Than 5 Students
- 596. Classes More Than 5 Students
- 【LeetCode】596、Classes More Than 5 Students
- 596. Classes More Than 5 Students
- case classes cannot have more than 22 parameters
- scala2.10.x case classes cannot have more than 22 parameters
- more than and less than
- no more than VS not more than
- “! LaTeX source files more than 5 years old!.”解决方案(转)
- Women talk more than men
- More than one order matters
- {Less} is more, than Css
- More Than A Feeling-Boston
- SVN提交改动时报错You must input more than 5 chars as comment!
- Tobacco do more harm than good
- log长度受限,无法完整打印
- 以下程序输出结果是____。
- 获取项目当前路径
- POJ 3626 Mud Puddles(BFS)【模板】
- 计算机网络面试题
- Classes More Than 5 Students
- Spring中指定applicationContext.xml等资源配置文件位置
- 详解Spring Cloud Config
- [LeetCode]167. Two Sum II
- Java中关键字的大致含义
- mybatis基础--作用域和生命周期
- 《javascrip编程精解》第二版习题练习(未完,根据自己学习进度更新)
- Android中static关键字的理解,及几个面试点
- 自定义控件三部曲之动画篇(八)——PropertyValuesHolder与Keyframe