how do we find nth highest in SQL

We've expanded our news coverage and improved our search! Visit news.oreilly.com for the latest or search for all things across O'Reilly!

Subject:		how do we find nth highest in SQL
Date:		2006-08-17 04:21:32
From:		navingujar
Response to: how do we find nth highest in SQL
One more way, select min(sal) from (select distinct sal from emp order by sal desc) where rownum <=n