How to get the 'top ten' from a SELECT count(*)

Hello!

I want to make something like a top ten list. Does anybody hava a smart idea to get only the first ten rows of a select like

SELECT count(*) amount, country
FROM customer
GROUP by customer
ORDER by amount

Thanks for any help

Carsten Received on Tue Apr 25 2000 - 00:00:00 CDT