-
MySQL LIMIT equivalent in MS SQL 2000
I am looking for the MS SQL equivalent of MySQL LIMIT.
I know that the code in MySQL is
SELECT col_name FROM tbl_name LIMIT x,y
where x = the starting row and y = the offset
E.g. SELECT movie_name FROM my_movies LIMIT 10,5
This will give me the records from 11-15
I would like to know what is the MS SQL equivalent for the above?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|