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.
  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.

  3. Madhivanan Moderator

    Search for Pagination in google
  4. baburk New Member

    I want records in between 5 and 11
  5. FrankKalis Moderator

    You can use your approach here:
    http://sql-server-performance.com/Community/forums/t/27961.aspx
  6. atulmar New Member

    Use Row_Number function,
    This is the main use of windowing functions in 2K5.
  7. Madhivanan Moderator

Share This Page