rongutiw
Valued Member
Points: 70
More actions
September 3, 2002 at 1:50 pm
#158680
What is the most efficient query to select all duplicate records in a large table?
Michael S. Armentrout
Ten Centuries
Points: 1178
September 3, 2002 at 2:17 pm
#435877
Assuming a key:
SELECT count(*), <column(s) that make the key>
FROM <table>
GROUP BY <column(s) that make the key>
HAVING count(*) > 1
Be great!
Mike
Be great!Michael
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply