1. We have moved to a new forum! There may be a few things not working properly so please let us know if you find a bug. Remember to use the bbCode [ sql ] tag for SQL statements.
New XenForo forum! Google Ads

how to find third highest record from table?

Discussion in 'SQL - Questions and Answers' started by davinder singh, Sep 29, 2006.

  1. davinder singh Guest

    Dialect: SQL 92
    davinder singh, Sep 29, 2006
    #1

  2. Dimitar Guest

    Dialect: SQL 92
    Please, see my answer to question number 47 ([A]here[/a]), which assumed natural ordering on column "a".
    Dimitar, Sep 30, 2006
    #2

  3. manithan Guest

    Dialect: MS SQL
    SQL:
    Select top 3 columnname from tablename
    
order by callsanswered DESC
    manithan, Oct 13, 2006
    #3

  4. Dhanalakshmi Guest

    Dialect: SQL 99
    SELECT TOP 1 *
    FROM (SELECT TOP 2*
    FROM tablename
    ORDER BY columnname DESC)e1
    ORDER BY Sal
    Dhanalakshmi, Dec 19, 2006
    #4

Share This Page