469,344 Members | 6,393 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,344 developers. It's quick & easy.

sql query

I have a table with the following columns..

id, domain, status

domain contains different major domains like aol.com,yahoo.com etc.

status has sent, bounce, defer

I want to do a count for each of these per domain, in a nested query

So it would look like this

Domain | Sent | Bounce | Defer
aol.com | 3000 | 34 | 34
Jul 11 '07 #1
1 706
hariharanmca
1,977 1GB
I have a table with the following columns..

id, domain, status

domain contains different major domains like aol.com,yahoo.com etc.

status has sent, bounce, defer

I want to do a count for each of these per domain, in a nested query

So it would look like this

Domain | Sent | Bounce | Defer
aol.com | 3000 | 34 | 34
you have to use crosstab Qry
Jul 11 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by jaysonsch | last post: by
9 posts views Thread by netpurpose | last post: by
3 posts views Thread by Harvey | last post: by
4 posts views Thread by Diamondback | last post: by
14 posts views Thread by Dave Thomas | last post: by
4 posts views Thread by Stan | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.