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
Vlad-Georg