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

advertisement

AddThis Social Bookmark Button
Subject:   how do we find nth highest in SQL
Date:   2006-08-17 04:21:27
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

1 to 2 of 2
1 to 2 of 2