By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,474 Members | 3,214 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,474 IT Pros & Developers. It's quick & easy.

Group By with Multiple Fields

P: n/a
Hi,
I have structure similar to the following table.

Month Year Category Brand SubBrand Currency Amount
Jan 2005 A 0001 UC USD 200
Jan 2005 A 0001 UC USD 500

My entire table has 35 Fields.
What I need is a query which performs the next result:

Month Year Category Brand SubBrand Currency Amount
Jan 2005 A 0001 UC USD 500

I have come up with this Query:

Select Month,Year,Category,Brand, SubBrand, Currency, SUM(Amount)
GROUP BY
Month,Year,Category,Brand, SubBrand, Currency;

But the result is not what should be expected... Searching over this
Group I found that "GROUP BY" is limited to 10 fields.. Can it be
affecting the result?

Regards
LC

Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.