sql count conditions

Posted by user1311030 on Stack Overflow See other posts from Stack Overflow or by user1311030
Published on 2012-04-03T17:19:45Z Indexed on 2012/04/03 17:30 UTC
Read the original article Hit count: 237

Filed under:
|

there!

I have this question, hope you guys can help me out.

So i have this table with two fields:

type and authorization

in type i have 2 different values: Raid and Hold

in authorization i have 2 different values: Accepted or Denied

I need to make a view that returns values like this:

TYPE:RAID     ACCEPTED:5          DENIED:7

Basically i need to know how many of the values in TYPE are Raid, and then how many of them are Accepted and Denied.

Thank you in advance!!

© Stack Overflow or respective owner

Related posts about case

Related posts about conditions