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

It ran ok if I am just running only the middle part

SELECT TOP 5 WITH TIES company_id
FROM sales
GROUP BY company_id
ORDER BY SUM(sale_amt) DESC

But if I ran the whole query, it gave me Invalid column name
'WITHTIES', for some reason, WithTies became one word when I ran it.

• Next in forum: Re: SQL: how to display top 5 then sum the rest
• Prev in forum: Re: problem with count, group by and ntext
• Thread view: Re: SQL: how to display top 5 then sum the rest

[Reply to this message]