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!
advertisement

Article:
  SQL Subqueries
Subject:   nth subquery if the records has same salary for two or three employees
Date:   2006-06-21 01:05:15
From:   JustQuery
Response to: nth subquery if the records has same salary for two or three employees

select sal from ( select rownum rn,sal from ( select distinct sal from emp where sal is not null order by sal ) ) where rn = &a