Dears ,
assumed i have the below table ,
WITH H_DATA AS (
SELECT 1 "A",4 "B",2 "C",1 "D",5 "E",4 "F" FROM DUAL
UNION
SELECT 3 "A",7 "B",5 "C",3 "D",66 "E",NULL "F" FROM DUAL
UNION
SELECT 3 "A",7 "B",3 "C",NULL "D",NULL "E",NULL "F" FROM DUAL)
SELECT * FROM H_DATA
OUT PUT
A B C D E F
1 4 2 1 5 4
3 7 3
3 7 5 3 66
i would like my output to eliminate the duplicates as below
| Header 1 | Header 2 | Header 3 | Header 4 | Header 5 | Header 6 |
|---|
| 1 | 2 | 4 | 5 | | |
| 3 | 7 | | | | |
| 3 | 5 | 7 | 66 | | |
OR order by row
| Header 1 | Header 2 | Header 3 | Header 4 | Header 5 | Header 6 |
|---|
| 1 | 1 | 2 | 4 | 4 | 5 |
| 3 | 3 | 7 | | | |
| 3 | 3 | 5 | 7 | 66 | |
is there possible way to do that?