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.

 

[DotNetGnat]

something like this:

SELECT A.CustID, A.CustName, A.CustTotal FROM Mytable A
WHERE A.CustTotal IN (SELECT TOP 100 CustTotal FROM Mytable B WHERE A.CustID=B.CustID ORDER BY CustTotal DESC)

-DNG

 

[micha123]

Sorry,
select top N
is not working in SYBASE
You will have to write it that way:

SET ROWCOUNT 100
SELECT A.CustID, A.CustName, A.CustTotal 
FROM Mytable A
ORDER BY CustTotal DESC

"A long life is when each day is full and every hour wide!"
(A Jewish Mentor)
M.