| Subject: | how do we find nth highest in SQL | |
| Date: | 2010-03-06 20:24:30 | |
| From: | Sikindar | |
|
Response to: how do we find nth highest in SQL
|
||
|
SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT b.sal) FROM EMP B WHERE a.sal<=b.Sal);
|
||
Women in Technology
Hear us Roar
