To find the nth highest from a table, use the SQL query with the ORDER BY and LIMIT clauses.

• Write a SQL query to select the column you want to find the nth highest from.

• Use the ORDER BY clause to sort...read more

select * from(select ename,esalary,dense_rank() over(order by esalary)dr from employee) tmp where dr=&n