Subject:   query for nth max
Date:   2007-08-25 02:05:46
From:   kashif094
Response to: how do we find nth highest in SQL

select * from emp e where 1=(select count(distinct sal) from emp where e.sal<=sal)

hi i am kashif can anyone tell me what is the concept of 1 in this query?

1 to 1 of 1
  1. query for nth max
    2007-10-25 05:02:21  jolly_cet [View]

1 to 1 of 1