Come on Dude....Just tell me.....what is "T" in that query

Thanks for ur reply....Some doubts..

select * from

(

select *,row_number()over(partition by employeeid order by salary desc)rid from salary

)T where rid<=2

what is rid and T

Question: Using the salary table on the left, write a SQL Server T-SQL query to find the Top 2 salaries for each employee. The result of the query...

i attached the excel file

Plz post me the query.....i didnt understand ur "Blah Blah"

Question: Using the salary table on the left, write a SQL Server T-SQL query to find the Top 2 salaries for each employee. The result of the query...

If u dont mind....Can u post query