max function?

[poolshark8or9]

i am counting the total number of orders for each customer, but i only want it to return the top 100 customers, the customer with the most orders, down to the customer with the 100th most orders.
How can i do this?
Thanks in advance.

 

[Dagon]

Does your database support OLAP functions ? If so, you can use functions like rank(), dense_rank or row_number().

 

[poolshark8or9]

no it doesnt, its an old sybase system

 

[juliane26]

ask in the sybase forum, because many dbms have a function or clause which is not sql standart but serve this purpose well.


Juliane