Tags

, , ,

SELECT UNIQUE RECORDS USING “GROUP BY”

I came across a way to get unique rows for a set of columns from a table. Consider the below table (MYTABLE).

COL1    COL2    COL3    COL4    COL5

—-    —-    —-    —-    —-

A         B       C      1       2

A         B       C      2       3

A         B       C      3       4

B         C       D      1       2

B         C       D      4       5

D         E       F      2       3

Say, If you want to see the below result.

COL1    COL2    COL3

—-    —-    —-

A        B       C

B        C       D

D        E       F

The above result shows unique rows identified for the first 3 columns COL1, COL2 and COL3 of the table.

To get above result, we can use the below query.

SELECT

COL1,COL2,COL3

FROM

MYTABLE

GROUP BY

COL1,COL2,COL3

WITH UR;

Advertisements