Posted by sweetpotatop on 10/02/39 11:44

Actually, I figure out "WITH TIES" isn't the function that I am looking
at.

Let me explain my scenario again. I want to see the top 5 compies'
sales, but any other companies' sales total with be sum up to a
category called "Other"

e.g.
Company Total Sales
Co. 1 $200
Co. 2 $150
Co. 3 $120
Co. 4 $100
Co. 5 $90
Other $900

• Next in forum: Help: 900 byte limit on stored procedure parameter?
• Prev in forum: Re: SQL: how to display top 5 then sum the rest
• Thread view: Re: SQL: how to display top 5 then sum the rest

[Reply to this message]