|Subject:||how do we find nth highest in SQL|
Response to: how do we find nth highest in SQL
Query for Nth Max (Highest)
select sal from emp t
where &n = (select count(sal)
from (select distinct sal from emp)
Showing messages 1 through 2 of 2.