I have a table which has customer_id and address field in it.some customers have same address. I have to search for those customer_id which has same address. How can i do it in webfocus.

This message has been edited. Last edited by: <Kathryn Henning>,

Something like this may do it. It depend if you would like to only identify the duplicated rows or not.

TABLE FILE CAR
PRINT COMPUTE SAME_CAR /A1 = IF LAST CAR EQ CAR THEN 'Y' ELSE 'N';
BY COUNTRY
BY CAR
BY MODEL
END

This will do it, but may not be very efficient.

table file customers

count entries
by address_element_1
by address_element_2
...

print [fields of interest]
by address_element_1
by address_element_2
...
by cust_id
where total count gt 1;
end

It will also miss duplicates, where there is spelling variation in the address elements.