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;

——————————————————————————————————–

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:

Working on Mainframes – Is Change to a different technology necessary
Important SQL CODES and ABEND CODES
SORT JOIN – TO JOIN TWO FILES BASED ON A KEY
KNOW YOUR MAINFRAME
REXX – INITIAL SETUP
HOW TO SUBMIT A BATCH JOB FROM THE CICS PROGRAM
CICS – EXEC interface block – EIBRESP Values
CICS – EXEC interface block Fields
Flow of control between COBOL programs, run units, and CICS
CICS INTERVIEW QUESTIONS
CICS TIPS
COBOL – COPY and INCLUDE statements
COBOL – PERFORMANCE IMPROVEMENT
COBOL – SIGN STORED IN COMP, COMP-3 AND DISPLAY FORMATS
SHORTEST COBOL PROGRAM
RESTART LOGIC IN COBOL DB2 Program
GOBACK – EXIT PROGRAM – STOP RUN
Continuation lines in COBOL
Computational items – COMP, COMP 1 , COMP 2, COMP 3
COBOL program format
cobol indicator area column-7 and area a and area b
COBOL INTERVIEW QUESTIONS
COBOL TIPS
COBOL COMPILER OPTIONS
The IDENTIFICATION DIVISION