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;
——————————————————————————————————–
In United States, If you would like to Earn Free Stocks, Credit card Points and Bank account Bonuses, Please visit My Finance Blog
——————————————————————————————————–
You may also like to look at:
F1 for Mainframe 