Women in Technology

Hear us Roar



Article:
  SQL Data Types
Subject:   how do we find nth highest in SQL
Date:   2004-10-08 07:32:14
From:   gansin
Please give the query for the finding the nth highest salary in SQL.
Main Topics Oldest First

Showing messages 1 through 5 of 5.

  • how do we find nth highest in SQL
    2007-11-21 02:20:53  Ani123 [View]

    With qry1 as (Select col1, col2, rownumber() over ()rownum from tablename order by col2 DESC)
    select * from qry1 where rownum=6;

    This finds the 6th highest;
  • how do we find nth highest in SQL
    2006-05-19 05:24:47  SPKUMAR [View]

    ok
  • how do we find nth highest in SQL
    2005-09-25 23:55:04  lalitpant [View]

  • how do we find nth highest in SQL
    2005-01-28 13:02:12  parangogoi [View]

    Please help me with the above query
  • how do we find nth highest in SQL
    2004-10-13 04:11:13  sunrek [View]

    can u please help me