select rows between m and n

sridevidb · #1 (**permalink**) 05-23-07, 05:19

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)

gvee · #2 (**permalink**) 05-23-07, 05:27

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

Internet Services

Web Development

Digital Marketing

Consumer Tech