SELECT DUPLICATE RECORDS

[BigJon BigJon]

Is it possible to 'see' the duplicate records?
In my table i want to see all records where values in colA AND colB occur more than once.
A B C D
1 2 3 4
2 3 4 5
3 4 5 6
4 5 6 7
2 3 9 9
2 2 9 9

so i want to see (select) rows 2 and 5

Any ideas, please?

i can get what causes duplicates by this...
SELECT colA,colB,colC,colD,COUNT(*) FROM t1 GROUP BY colA,colB HAVING COUNT(*)>1
but then i have to
SELECT * FROM t1 WHERE colA=2 AND colB=3
but i need a lot of SELECT statements for my large tables!!



Edited 1 time(s). Last edit at 10/31/2007 09:35AM by BigJon BigJon.