Thread: query to display only the distinct data and not the identical ones
View Single Post
  #4 (permalink)  
Old 07-26-2007, 06:50 PM
Unregistered
 
Posts: n/a
Thumbs up ANY answer. Re: query to display only the distinct data and not the identical ones
This query will also work
select id from
(select id,count(*) count
from TableName
group by id)
where count=1;

Sheetal
Reply With Quote