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: 210

Filed under:

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

Related posts about case

Notes on Oracle BPM PS6 Adaptive Case Management

as seen on Oracle Blogs - Search for 'Oracle Blogs'
v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} I have recently been looking at the latest release of the BPM Case Management feature in the Oracle BPM PS6 release. I had put together some… >>> More
rename file names from lower case to upper case

as seen on Super User - Search for 'Super User'
Hello, I have about 2k of file that are currently in lower case like: file_one.cfr file_two.cfr .... I am searching for a fast way to rename them to upper case so they would be like; FILE_ONE.cfr FILE_TWO.cfr .... If I use from my shell; for i in *; do mv $i `echo $i | tr [:lower:] [:upper:]`;… >>> More
rename file names from lower case to upper case

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I have about 2k of file that are currently in lower case like: file_one.cfr file_two.cfr .... I am searching for a fast way to rename them to upper case so they would be like; FILE_ONE.cfr FILE_TWO.cfr .... If I use from my shell; for i in *; do mv $i `echo $i | tr [:lower:] [:upper:]`;… >>> More
c - convert a mixed-case string to all lower case

as seen on Stack Overflow - Search for 'Stack Overflow'
is the best/cleanest way to just do a for loop iterating through each position and call tolower() on it? >>> More
Proper Case Title Case Question

as seen on Stack Overflow - Search for 'Stack Overflow'
What am i doing wrong here? I want the users name to be shown in the output as propercase but I cant figure it out. string proper = this.xTripNameTextBox.Text; CultureInfo properCase = System.Threading.Thread.CurrentThread.CurrentCulture; TextInfo currentInfo = properCase.TextInfo; proper = currentInfo… >>> More

Related posts about conditions

Do most companies not know how to write software?

as seen on Programmers - Search for 'Programmers'
If you're an active reader here, try to think about how many times you've heard (and even agreed) when someone here has told someone else to start looking for a new job. Personally, I've seen it a lot more than I expected: it's almost starting to sound cliche. I get that there are bound to be a number… >>> More
B.S.in Computer Science, weak eyes => career change

as seen on Programmers - Search for 'Programmers'
So I am going to earn B.S. in Computer Science soon. I like computers. I like programming. The problem is that my eyes are very weak. Depending on their condition, I can only put in about 6 hours in front of computer a day. If I push myself, I have trouble even keeping my eyes open because of soreness/pain… >>> More
How to make the working environment of a programmer less shiny?

as seen on Programmers - Search for 'Programmers'
Last year I had a sport accident and since then my left eye is a little bit sensitive. Especially if looking in bright and shiny colors, I get tired very fast and can't literally focus on anything. White is the worst color ever! Unfortunately most application that I use in my work environment (Firefox… >>> More
How should developers handle subpar working conditions? [closed]

as seen on Programmers - Search for 'Programmers'
I have been working in my current job for less than a year and at the beginning didn't have the courage to say anything about the things that bothered me. Now I'm a bit fed up and need things to get better. The first problem is not random but I'll mention it anyway. We are running out of space so… >>> More
Not getting paid for hours you've worked?

as seen on Programmers - Search for 'Programmers'
So I was reading from a previous thread about App vs Game Development Here Which brought me to this site: Clicky Alot of it talked about devs working something like 85 hours a week.....and not getting paid overtime, or anything. Just getting paid for the 40 hours.....Is this normal for most software… >>> More