ONJava.com -- The Independent Source for Enterprise Java
oreilly.comSafari Books Online.Conferences.

advertisement

AddThis Social Bookmark Button
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