| 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 |
||
Women in Technology
Hear us Roar
