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:   2005-01-18 21:03:32
From:   hiexplain
Response to: how do we find nth highest in SQL

thanks a lot
"select sal from emp t
where &n = (select count(sal)
from (select distinct sal from emp)
where t.sal<=sal);"
it is working fine
could u please let me know how it works...
thanks and reguards
surendra