Finding duplicates

[Ruslan Zasukhin]

On 7/2/08 10:12 PM, "Mr. Bart Pietercil" <bart.pietercil at gmail.com> wrote:

Hi Bart,

> Hi List, Ruslan
> 
> It's late and I'm tired so might as well ask for the solution:
> 
> how do I separate the records that based on firstname and lastname are
> doubles in the table from the rest.
> So I want to see the doubles (not the distinct). Probably need to use
> distinct in a subselect but my head refuses cooperation.

First idea:

SELECT  firsName, LastName, RecID
FROM T
GROUP BY firsName, LastName, RecID


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]