Troy's Blog
Friday, March 28, 2008
Find duplicate rows in table
If you need to find the duplicate rows in a database table you can use this query to do that. SELECT
COL_01
, COUNT(*) FROM
TABLE
group by
COL_01
having count(*) > 1
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment