Query help

Z

Zwi2000

Hi,

I have a table with Id's and other fields. I want to select all records
where the Id is not unique, meaning there is another record with the same
Id.

Help appreciated.

Z
 
B

Bruce Loving

select * from table
where id in (select id from table group by ID
having count(id) > 1)
 
Top