hello,
i am working on a table having a single column of 10 rows(For simplicity). out of the 10 rows of data, one of the data is distinct from the rest while the data in the remaining 9 rows are exactly identical. i am looking for a query which display only the distinct data and not the identical ones. here the data type is number. can anybody help me out.

SELECT c FROM tn GROUP BY c HAVING count(c) = 1;
This will give you all values that are present exactly once in the column.

SQL QUERY

select <coloumn name>, count(*) from <tablename> group by <columnname> having count(*) <=1;

This query will also work
select id from
(select id,count(*) count
from TableName
group by id)
where count=1;

Sheetal