开发者

How to find repeated Rows?

开发者 https://www.devze.com 2023-01-11 06:11 出处:网络
i am having 75000row records i need to get how ma开发者_运维问答ny of them repeated,how can i do that in MySQL Query?This query will return all duplicate rows, and the number of times they are duplica

i am having 75000 row records i need to get how ma开发者_运维问答ny of them repeated,how can i do that in MySQL Query?


This query will return all duplicate rows, and the number of times they are duplicated

SELECT Col1, Col2,..ColLast, Count(*) As NumDups FROM YourTable
GROUP BY Col1,Col2,...,ColLast
HAVING COUNT(*) > 1;
0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号