Re: select 2nd - 5th records?

From: John Spencer (MVP) (spencer4_at_comcast.net)
Date: 02/29/04 

Date: Sun, 29 Feb 2004 09:12:05 -0500

Two methods I can think of:

Select the Top 4 of your Top 5 sorted in reverse order.

Or create a query that gets the top 1 vice the top 5. Then do an unmatched
query on the two queries.

jim wrote:
>
> hi,
> i know i can get top 5th of records by
> "select top 5 ..." statement.
> but, how can i get 2nd - 5th records but no 1st statement?
>
> in mysql, i can use "select ... limit 2,5".
> in oracle, i can use "select ... rownum >2 and rownum < 5"
>
> how can i do that in access?
>
> thanks,
> jim

Relevant Pages

  • Re: delete first 15 records
    ... Use 2 queries. ... Create a Select query ordered by the field you want to ... SELECT TOP 15 Table1.* ... > Jim. ...
    (microsoft.public.access.forms)
  • RE: Dynamically referencing a recordset?
    ... through that recordset to set the query parameters in VBA. ... to be the one who had to modify 1440 queries if there is a change in the ... different table schema, then you need 3, one for each record type. ... This is a database that tracks the production on records in another ...
    (microsoft.public.access.modulesdaovba)
  • Re: Was: what does "serialization" mean?
    ... > the specific queries up front. ... that the NEXT time the query is run the query is fast, ... data base, don't know squat" when in fact the Donald clone doesn't ... >> WHATEVER would probably be a separate query to summarize total sales. ...
    (comp.programming)
  • Re: Official Status of SQLServer 2005 ADP
    ... I have said that the support for SQL passthrough ... queries under MDB was bad and worst than the one offered by ADP while you ... > attempt to "pass through" every Access query against a linked ODBC ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Cluster synchronize
    ... queries per unit time. ... CPU is the ONLY bottleneck. ... increase in query capacity. ... queries that perform sequential I/O or queries performing random I/O. ...
    (microsoft.public.sqlserver.clustering)