如何查找出数据库中指定字段相同的记录

代码如下:
SELECT *
FROM student AS A
WHERE (SELECT COUNT(*) FROM student WHERE Sno=A.Sno)>1

posted @ 2016-01-12 15:33 Eaglery 阅读(309) 评论(0) 收藏举报