Home Forums SQL Server 7,2000 General Select nthrow to mth row RE: Select nthrow to mth row

  • September 5, 2015 at 1:46 am

    #1824810

    SELECT *

    FROM TableName

    ORDER BY ColumnName ASC

    OFFSET 40 ROWS

    FETCH NEXT 10 ROWS ONLY

    will get 40th row to 50th row

    Chandrasekhar