Query help

  • Thread starter Thread starter Zwi2000
  • Start date Start date
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
 
select * from table
where id in (select id from table group by ID
having count(id) > 1)
 
Back
Top