There is a table courses with columns: student and class
Please list out all classes which have more than or equal to 5 students.
For example, the table:
| student | class |
|---|---|
| A | Math |
| B | English |
| C | Math |
| D | Biology |
| E | Math |
| F | Computer |
| G | Math |
| H | Math |
| I | Math |
Should output:
| class |
|---|
| Math |
Note:
The students should not be counted duplicate in each course.
SELECT DISTINCT class
FROM courses
GROUP BY class
HAVING count(DISTINCT student) >= 5;
There is a table courses with columns: student and class ...
Conditional SELECT There is a table World A country is bi...
mysql SELECT GREATEST(2,0);//2SELECT GREATEST('B','A','C'...
insert into tablename(a,b,c) select a,b,c from dual 注意千万...
a, .c { float: left; width: 130px; } select ...
LIMIT SELECT * FROM city WHERE countrycode='C...
example：select json_extract_c(json, "$.totalDays"), json ...
SELECT c1, SUBSTR (MAX (SYS_CONNECT_BY_PATH (c2, '，')), 2...
SELECT c.full_name,MOD(ROWNUM,8) yu FROM t_company c ORDE...
1. 问题描述 MySQL 5.7.5及以上功能依赖检测功能。如果启用了ONLY_FULL_GROUP_BY SQ...
本文标题：180605_Conditional SELECT with C
本文链接：https://www.haomeiwen.com/subject/unqpsftx.html
网友评论