WINDOW FUNCTION ARE EASY TO USE TO PERFORM OPERATIONS ON SET OF ROWS

CREATE TABLE #SOURCE ( ID INT, NAME VARCHAR(50))

INSERT INTO #SOURCE

VALUES (1, 'ABC'), (3,'PQR' ), (4, 'XYZ')

SELECT ID,NAME,ROW_NUMBER() OVER...