查出重复的学生名
NO | name |
1 | JONE |
2 | LILY |
3 | TOM |
4 | LILY |
5 | TOM |
方法一:
SELECT name
FROM(SELECT name, count(name) num
FROM table) t
WHERE num > 1;
方法二(更优):
SELECT name
FROM table
GROUP BY name
HAVING COUNT(name) > 1;
NO | name |
1 | JONE |
2 | LILY |
3 | TOM |
4 | LILY |
5 | TOM |
方法一:
SELECT name
FROM(SELECT name, count(name) num
FROM table) t
WHERE num > 1;
方法二(更优):
SELECT name
FROM table
GROUP BY name
HAVING COUNT(name) > 1;