依stud_no欄位查詢stud_no欄位資料重複的筆數
SELECT stud_no, COUNT(*) AS count
FROM student_data
GROUP BY stud_no
HAVING (COUNT(*) > 1)
---------------------------------
已經查出那些資料重複，又要帶出相關的完整資料時
SELECT * FROM student_data
WHERE stud_no IN (
SELECT stud_no
FROM student_data
GROUP BY stud_no
HAVING (COUNT(*) > 1)
)
全站熱搜
留言列表
