To find nth highest salaried employee?

Question

I am trying the below query

select * from (select *,row_number() over(order by salary)r from p ) where r =&n;

I am trying this also where r = 3; I am getting the below error:

Error Code: 1248. Every derived table must have its own alias

Ross Bush · Answer

The error is clear:

Every derived table -> (select *,row_number() over(order by salary)r from p )

Must have its own alias -> (select *,row_number() over(order by salary)r from p) as alias where alias.r = 3