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

Filed under:
|
|

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

Related posts about sql

Related posts about select