Women in Technology

Hear us Roar



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?

Full Threads Newest First

Showing messages 1 through 1 of 1.

  • query for nth max
    2007-10-25 05:02:21  jolly_cet [View]

    1 specifies the position..