SQL query: Return duplicates

Hi,
could you please assist me with a SQL query. I need to analyse some data. I have two fields..call them fld1 and fld2.

The database should never have the same combination of fld1 and fld2.

so if record 1 has fld1=1 and fld2 = 4 then I shouldnt have this combination in any other record...
but these duplicates unfortunately exist and I have to find them all. I have over 30 000 records in the table.

Can you assist me with a query to find all records where the combination of fld1 and fld2 appears in more than 1 record?

Thanks in advance

Something like:

SELECT fld1, fld2, count(fld1) as cnt from table group by fld1,fld2

I haven't tested it, but give it a try. Any duplicates should have CNT >= 2

What about SELECT DISTINCT or am I reading the question wrong?

SELECT fld1, fld2, COUNT(*) AS CountOf FROM tblPatient GROUP BY fld1, fld2 HAVING COUNT(*) > 1