If you have a table called T1, and the columns are c1, c2 and c3 then this query would show you the duplicate values.
SELECT C1, C2, C3, count(*)
GROUP BY C1, C2, C3
HAVING COUNT(*) <> 1</pre>
Last Wiki Answer Submitted: March 15, 2010 4:17 am by Denny Cherry64,520 pts.