Finding duplicates

[Thorsten Hohage]

Hi Bart,

On 2008-02-07, at 21:12, Mr. Bart Pietercil wrote:
> 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.



What do you mean with separate? Do you want to set a flag in that row,  
delete them, ...???


regards

Thorsten Hohage
--
objectmanufactur.com - Hamburg,Germany