Hi Joao,

If you have a table duplicate with a column name and want to find out which records have duplicate value in the column name, then you may use following sql:

select name, count(*)
from duplicate
group by name
having count(*) > 1

Hope this helps.
Regards,
Georg

>Hi
>
>How do i select duplicate field values from a table with a SQL select statement ?
>
>Thank you all,
>
>João