How to check for mutiple rows with same data?

Can anyone advise how do I check multiple rows with same data?

E.g.

I have 2 rows with following values:

Cola         Colb  Colc
TYPE_APPLE   123   abc
Colb         Colb  Colc
TYPE_APPLE   123   abc

I want to write an SQL query which will not select data of multiple rows which contain the same data as above. How should I write the query?

DISTINCT will combine identical rows. GROUP BY will combine them and allow you to know which ones had multiples using COUNT(*). To meet your "not select data of multiple rows" requirement you will need to add a HAVING clause. Your query will look something like this:

SELECT cola, colb, colc FROM T1 GROUP BY cola, colb, colc HAVING count(*) = 1;

SQL Fiddle Demonstration

StackExchange Database Administrators Q#35525, answer score: 4