> Normally I'd write a
> query with a sub select to get that information - something like this:
Normally I'd NOT use a subquery ;-)
> SELECT a.*
> FROM table a
> WHERE a.ssn IN (SELECT b.ssn FROM table b GROUP BY b.ssn HAVING
> count(b.ssn) > 1);
>
> However, I don't have MySQL 4.1.x so th
Adam wrote:
All,
I've got data listing people's identification details including first
and last name, social, and status in the application. Given this data, I
want to know how many duplicate socials I have. Normally I'd write a
query with a sub select to get that information - something like
All,
I've got data listing people's identification details including first
and last name, social, and status in the application. Given this data,
I want to know how many duplicate socials I have. Normally I'd write a
query with a sub select to get that information - something like this:
SELECT
