Women in Technology

Hear us Roar



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