站內搜尋

Monday, August 26, 2013

[MYSQL] 找出重複的資料

SELECT * FROM my_table GROUP BY name HAVING count(*)>1

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)