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: 235
case
|conditions
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