On Fri, 29 Aug 2003 12:42:03 -0700
Grant Cooper <[EMAIL PROTECTED]> wrote:
> I'm trying to get a query to work by listing all the people in a row with
> the same last name and first name.
>
> key, fname, lname
> 1 ,John, Smith
> 4, John, Smith
> 5, Cody,Edwards
> 2, Cody, Edwards
SELECT fname,ln
Fortuno, Adam wrote:
I would suggest a SQL statement like this to get the results you're looking
for.
SELECT COUNT(a.id), a.lname, a.fname
FROM people AS a
GROUP BY a.lname, a.fname
HAVING COUNT(a.id) > 1;
That's a great way of doing it if Grant doesn't need the IDs, which he
*did* have listed in
en from that list, only
reviewing those with a count greater than 1. Presumably anything with a
count of 1 is unique in the table.
Regards,
Adam
-----Original Message-----
From: Grant Cooper [mailto:[EMAIL PROTECTED]
Sent: Friday, August 29, 2003 3:42 PM
To: [EMAIL PROTECTED]
Subject: listing all pe
I'm trying to get a query to work by listing all the people in a row with
the same last name and first name.
key, fname, lname
1 ,John, Smith
4, John, Smith
5, Cody,Edwards
2, Cody, Edwards
Don't list anyone that has a unique first name last name. Is this possible?
Trying to use the Count comman