View Single Post
  #2 (permalink)  
Old 07-13-2007, 05:37 PM
Dimirar
 
Posts: n/a
Default ANY answer. Re: query to display only the distinct data and not the identical ones

[sql] select c from tn group by c having count(c) = 1;[/sql]
This will give you all values that are present exactly once in the column.
Reply With Quote