How do I return count and not count in a SQL query?
Posted
by Gribbler
on Stack Overflow
See other posts from Stack Overflow
or by Gribbler
Published on 2010-04-13T14:41:52Z
Indexed on
2010/04/14
4:03 UTC
Read the original article
Hit count: 240
Hi,
If I have a table
AgentID | IsNew | TeamID
1 N 1
2 Y 2
3 Y 2
4 N 2
5 Y 1
I want to return the following from a query:
Team | CountIsNew = N | CountIsNew = Y
1 1 1
2 1 2
Is there a way I can do this?
Using Oracle 10
© Stack Overflow or respective owner