Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2007
    Posts
    10

    select rows between m and n

    hi
    can anyone tell me what is the syntax of the select statement to select m to n records in a table in sybase(t-sql)

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Records beginning with M and N ?
    I don't think your question is clear enough - please tell us what you wish to achieve.
    Here's a guess at what you want
    Code:
    SELECT *
    FROM employees
    WHERE age BETWEEN 20 AND 30
    George
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •