Re: I need a query

From: Ray Higdon (sqlhigdon_at_nospam.yahoo.com)
Date: 03/13/04 

Date: Sat, 13 Mar 2004 08:31:04 -0500

Top N means absolutely nothing without an order by, you are not guaranteed
order even if you have a clustered index without an order by. 

-- 
Ray Higdon MCSE, MCDBA, CCNA
---
"Mehran" <anonymous@discussions.microsoft.com> wrote in message
news:c4b401c408de$22377c00$a401280a@phx.gbl...
Hi!
Thank you for your reply.
It doesnīt matter. The query is
SELECT * FROM MONEY
When i run this query i get 100 rows. But i want to see
rows between 20 and 40. I can see top 20. Itīs easy
SELECT TOP 20 FROM MONEY
But my question is, is it possible to run a query to get
row between 20 and 40 or 40 and 60 etc.
Mybe like this
SELECT BETWEEN 20 TO 40 FROM MONEY :-)
Thank  you once again for your reply
Kind regards
Mehran
>-----Original Message-----
>Can you post your query? What are you using as criteria
for the top 100?
>
>-- 
>Ray Higdon MCSE, MCDBA, CCNA
>---
>"Mehran" <anonymous@discussions.microsoft.com> wrote in
message
>news:c5ee01c40887$7117aa40$a101280a@phx.gbl...
>Hi!
>
>Think that you get 100 rows in result of a query. But i
>donīt want to see all of them. I want to see the rows
>between 20 and 40. Is it possible to do a query who get
>the rows between 20 and 40???
>
>Thank you for helping me
>Kind regards
>Mehran
>
>
>.
>

Relevant Pages

  • Re: Please Help with Query Calculations
    ... As for the other fields I put SUM but its not summing them up. ... of the query, go up to View and select Totals. ... maybe a few more fields) and an Sum the Amounts Owed and Amounts Paid ... is several dates of when people were billed money and paid money. ...
    (microsoft.public.access.queries)
  • Re: Doctors Income
    ... That you pose the query you do in the vague/open-ended form in a way ... Even way out here in the bowels of fly-over country, I'm often pleasantly surprised to discover the depth and breadth of info that the libraries place at my fingertips. ... Of course, every other budget cycle the libraries are targets for the politicians who want to spend the money on sexier projects, so vigilance is always necessary. ...
    (soc.retirement)
  • Re: Update Query & Expression Help
    ... AccountID integer, ... Qtr1 money, ... > I have a Query I want to run, to update a field in the MASTER table. ... > examine 4 fields each record of MASTER to find the Highest Max value; ...
    (microsoft.public.access.queries)
  • Re: My design - where did I go wrong?
    ... > money S1, ... Is it the combination of CustID and SaleDate? ... then the query will be as fast as possible. ... beyond the 4th decimal is lost in a money data type, ...
    (comp.databases.ms-sqlserver)
  • Re: Time fields
    ... Put two calculated fields in the query: ... time difference and the other to calculate the money. ... <MS ACCESS MVP> ...
    (microsoft.public.access.dataaccess.pages)