SELECT

tCOL1COL3.COL1 AS COL1,

tCOL2.COL2 AS COL2,

tCOL1COL3.COL3 AS COL3

FROM

(

SELECT

COL1,

COL3,

RANK () OVER(ORDER BY COL1 ASC) AS ROWNUMBER

FROM

SQLSerC /* YOUR TABLE HAVING COLUMNS COL1 (INT), COL2(INT), COL3(INT) */

)tCOL1COL3

INNER JOIN

(

SELECT

COL2,

RANK () OVER(ORDER BY COL2) AS ROWNUMBER

FROM

SQLSerC /* YOUR TABLE HAVING COLUMNS COL1 (INT), COL2(INT), COL3(INT) */

)tCOL2

ON

tCOL1COL3.ROWNUMBER = tCOL2.ROWNUMBER

Sample Run Results ...

RunStatusCOL1COL2COL3

Before Run ... 538

Before Run ... 629

Before Run ... 7110

RunStatusCOL1COL2COL3

After Run ...518

After Run ...629

After Run ...7310