Display the first 10 records

[shahatul]

I have a query which has more 100 records. I want to display only first 10 records. For example:
Select Customer.Company_Name, Max(Orders.Order_Date) AS dMostRecent From Customer ;
Left Join Orders ;
On Customer.Customer_ID = Orders.Customer_ID ;
Group By 1 ;
Into Cursor MostRecentOrder

Any idea?
Thanks in Advance.

 

[baltman]

Try this:

Select TOP 10 dist Customer.Company_Name, ;
Max(Orders.Order_Date) AS dMostRecent ;
GROUP BY 1 ;
ORDER BY 2 descending ;
FROM Customer,Orders ;
WHERE Customer.Customer_ID = Orders.Customer_ID ;
INTO CURSOR MostRecentOrder

Brian

 

[shahatul]

Thank you very much Brian

Warm regards
Shah AV