General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
I do it in two steps
SELECT ssn, COUNT(*) as countssn ;
FROM sometabl ;
GROUP BY ssn ;
INTO CURSOR dupessns
SELECT custname, amt, ssn ;
FROM sometabl ;
WHERE ssn IN (SELECT ssn from dupessns) ;
ORDER BY ssn
>Thanks, that returned a count of how many. I don't suppose there is a way to list those returned rows with name and amt along with the found duplicate ssn?
>
>Thanks
>Nick Patel
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only