如何查找出数据库中指定字段相同的记录
代码如下:
SELECT *
FROM student AS A
WHERE (SELECT COUNT(*) FROM student WHERE Sno=A.Sno)>1
SELECT *
FROM student AS A
WHERE (SELECT COUNT(*) FROM student WHERE Sno=A.Sno)>1
转载于:https://www.cnblogs.com/Eaglery/p/5124485.html