Thanks Guys It helped me lot.

Also I tried it to sortby Organizations since GrandTotal needs to appear on bottom

SELECT [SlNo#] = ROW_NUMBER() OVER(ORDER BY CASE WHEN ORGANIZATIONNAME = 'GrandTotal' THEN...

I'm Sorry, I confudsed the question; however, my target is to return both the values like ID and Code result should be as

ID Code

-- -----

1 ...

Thanks dude 🙂

THANKS ROB. IT HELPS LOT 🙂