We help IT Professionals succeed at work.
Get Started

SQL Select to summarize data and total

tmajor99 asked
Last Modified: 2016-02-02
I need a SQL Select that will summarize data by category and code.  Here is what my table rows look like:

Product     Code        Category    
1203           O              Online          
3900           H              Tools          
4999           X               Heaters      
5009           O              Heaters      
8990                            Tools          
3111           H              Tools          
5115           O              Tools            

I need a SQL select that will summarize the data by Category and Code like this:
                           O             X            H       Other         Total    
Online               1                                                          1
Tools                 1                             2          1               4
Heaters            1               1                                          2

Summary         3              1            2          1                7
Watch Question
DBA and Business Intelligence Developer
This problem has been solved!
Unlock 2 Answers and 5 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE