By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
5 rows affected
EMPID | CNT | EMP1 | EMP2 |
---|---|---|---|
EM2 | 2 | EM3 | EM4 |
EMPID | CNT | INDEX_OF_EMP | EMP |
---|---|---|---|
EM2 | 2 | 1 | EM3 |
EM2 | 2 | 2 | EM4 |
5 rows affected
EMPID | CNT | EMP1 | EMP2 |
---|---|---|---|
EM2 | 2 | EM3 | EM4 |
EMPID | CNT | INDEX_OF_EMP | EMP |
---|---|---|---|
EM2 | 2 | 1 | EM3 |
EM2 | 2 | 2 | EM4 |