Hello.
Does anyone know if I can construct a query that selects records that have duplicate data in a given field?
Thank you
select givenfield, count(givenfield) as dup_count
from table1
group by givenfield
having dup_count > 1
select t1.*
from
(
select field_3, count(field_3) as dup_count
from "D:\table1.dbf"
group by field_3
having dup_count > 1
) as t0
left join "D:\table1.dbf" as t1 on t0.field_3=t1.field_3
I need to identify the same value for the field_3 where field_1 and field_2 are diferentes
Return to DBF Commander Professional
Users browsing this forum: No registered users and 0 guests