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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Visio 2010 - Organization Chart Wizard - Hebrew Excel Database 0
Grouping Names in Mail Merge 0
Autonumber field in Excel that behaves the same as Access 0
MS Project 2010: Predecessor Name Display 0
Creating task with Given ID 0
Auto populate value from one task to another in MS PROJECT 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
M.S. Word 365 1

Top