Thread
:
query to display only the distinct data and not the identical ones
View Single Post
#
2
(
permalink
)
07-13-2007, 05:37 PM
Dimirar
Posts: n/a
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.
Dimirar