Only 10 records returned in a query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jon - 13 Apr 2008 04:35 GMT

Hi
I have a query which returns 90 + records how can I put a condition so I
only see the first 10 records?
the SQL I have is

SELECT quFirstTimePass2.Job, Count(quFirstTimePass2.OrderNo) AS NumberOff
FROM quFirstTimePass2
GROUP BY quFirstTimePass2.Job
ORDER BY Count(quFirstTimePass2.OrderNo) DESC;
Regards

Jon

Reply to this Message

Tom van Stiphout - 13 Apr 2008 05:34 GMT

Have you tried the TOP predicate?
-Tom.

>Hi
>I have a query which returns 90 + records how can I put a condition so I
[quoted text clipped - 8 lines]
>
>Jon

Reply to this Message

jon - 13 Apr 2008 05:49 GMT

No
I will try

Thanks

Jon

> Have you tried the TOP predicate?
> -Tom.
[quoted text clipped - 11 lines]
>>
>>Jon

Reply to this Message

jon - 13 Apr 2008 05:55 GMT

Done and dusted
Thanks learnt something new

Jon

> Have you tried the TOP predicate?
> -Tom.
[quoted text clipped - 11 lines]
>>
>>Jon

Reply to this Message