SQL: SELECTing Duplicates

Let's project Column1 in Table1 and look for duplicates. The SQL syntax for this is:

SELECT Column1 FROM Table1
GROUP BY Column1
HAVING Count(*) &gt; 1

NOTE: the argument of Count() relates to the projections of GROUP BY.

mod date: 2000-12-24T22:52:36.000Z