SQL Server Performance

Select next 8 records

Discussion in 'SQL Server 2005 General Developer Questions' started by baburk, Aug 24, 2008.

  1. baburk New Member

    Hi all,
    We are selecting top(5) built in function to select top 5 records.
    If we want to select the records after 5 means how can we able to select.
    Thanks in advance.
    Babu kumarasamy.
    baburk, Aug 24, 2008
    #2

  2. parveen New Member

    Hi,
    Do you mean something like this ?
    SELECT * FROM TABLE WHERE Column_ID NOT IN (SELECT TOP 5 Column_ID FROM TABLE)
    Regards
    parveen.

    parveen, Aug 24, 2008
    #3

  3. Madhivanan Moderator

    Search for Pagination in google
    Madhivanan, Aug 25, 2008
    #4

  4. baburk New Member

    I want records in between 5 and 11
    baburk, Aug 25, 2008
    #5

  5. FrankKalis Moderator

    You can use your approach here:
    http://sql-server-performance.com/Community/forums/t/27961.aspx
    FrankKalis, Aug 25, 2008
    #6

  6. atulmar New Member

    Use Row_Number function,
    This is the main use of windowing functions in 2K5.
    atulmar, Aug 25, 2008
    #7

  7. Madhivanan Moderator

    Madhivanan, Aug 26, 2008
    #8

Share This Page