How to retrieve rows from position n to position m from table in Access 2003
- From: Orgil <orgilhp@xxxxxxxxx>
- Date: Thu, 30 Aug 2007 23:10:02 -0700
Hi all
I'm using MS Access 2003 database.
Now I want to write a query that retrieves "n" rows that are not TOP
rows but starts from position "m".
For example: I have a table "Notes". Which has 37 rows and I need to
get rows from 20th to 30th but not need to get TOP 10 rows and last 7
rows.
I tried this:
SELECT TOP 30 * FROM Notes
WHERE [id] NOT IN
(SELECT TOP 20 [id] FROM Notes ORDER BY [id]) ORDER BY [id];
But it results TOP 30 rows without any error.
If I were using MSSQL2000, this query could be fine. But I am using
Access and it doesn't work !
Please post me if you have any idea !
.... Orgil
.
- Follow-Ups:
- Prev by Date: Left Join and Where Statements
- Next by Date: Re: Left Join and Where Statements
- Previous by thread: Left Join and Where Statements
- Next by thread: Re: How to retrieve rows from position n to position m from table in Access 2003
- Index(es):