Hi venkidesaik,

I thought below query met you requirement.Have a look into this ad try it.

;with cte as

(

select ROW_NUMBER() over ( order by name) as RN,* from MySampleTable

)

select

(case when ...