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

get the value of the 3rd row from bottom?

Discussion in 'SQL - Questions and Answers' started by anand, Aug 17, 2006.

  1. anand Guest

    Dialect: SQL 92
    anand, Aug 17, 2006
    #1

  2. Dimitar Guest

    Dialect: SQL 92
    SQL:

    
select min(a) from t where a > (select min(a) from t where a > (select min(a) from t));

    What will the above return if the table was less than 3 in cardinality?
    Dimitar, Aug 21, 2006
    #2

  3. Unregistered Guest

    SELECT MIN(ShippingId) AS Expr1
    FROM (SELECT TOP (3) ShippingId
    FROM Shipping
    ORDER BY ShippingId DESC) AS Expr2
    Unregistered, Jan 18, 2008
    #3

Share This Page