SQL Recipes a FREE cookbook of SQL queries and examples - View Single Post - query to display only the distinct data and not the identical ones

#3 (**permalink**) 07-25-2007, 06:56 PM

Quote:

Originally Posted by bkateertha

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.

SQL QUERY

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