Even though i am using the below code it is 235 chars( from the cte query it is 280 chars)

select s1.* from(

select s.*,row_number() over(order by SalesAmount desc) R

from dbo.SalesOrder...

Thanks for the reply ..

the condition is the query should be within 140 characters..

Rajesh.