Search found 1 match

by mgbizintel
Mon Oct 05, 2015 9:50 pm
Forum: New to Vertica SQL
Topic: Sum by category
Replies: 2
Views: 17028

Sum by category

Hello. I have a Vertica table that looks something like this: Company Product Revenue A Widgets 15 A Cat food 5 B Sneakers 50 B Widgets 12 B Cat food 95 B Cat food 5 What I am attempting to do is summarize this table so that it looks like this: Company Widgets_rev Cat_food_rev Sneakers_rev A 15 5 (n...

Go to advanced search