I want to create single rank based on two columns from a single record.
I have sample source data like below
|Current ID||Previous ID|
Trying to derive a rank as below
Please help in writing query for the same.
Solved! Go to Solution.