已知grade表如下,要求找出分数重复的数据,下列选项中SQL语句正确的是()
sno | mark |
1 | 85 |
2 | 95 |
3 | 85 |
4 | 78 |
sno | mark |
1 | 85 |
2 | 95 |
3 | 85 |
4 | 78 |
SELECT mark FROM (
SELECT mark,COUNT(mark) AS num
FROM grade
GROUP BY mark
) AS STATISTIC
WHERE num>1
SELECT mark,COUNT(mark)>1
FROM grade
GROUP BY mark
SELECT mark FROM (
SELECT mark,COUNT(mark) AS num
FROM grade
GROUP BY mark
)
WHERE num>1
SELECT mark
FROM grade
GROUP BY mark
WHERE COUNT(mark)>1
SELECT mark FROM grade having count(mark)>1;