Only 10 records returned in a query

[jon]

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

 

[Tom van Stiphout]

Have you tried the TOP predicate?
-Tom.

 

[jon]

No
I will try

Thanks

Jon

Have you tried the TOP predicate?
-Tom.

 

[jon]

Done and dusted
Thanks learnt something new

Jon