|
-
Apr 10th, 2007, 05:40 AM
#1
Thread Starter
Addicted Member
SQL COUNT(*) Function
I am tring to make a query but I am a beginner in SQL commands. Example is following:

There is the table which is my database and Query will look like that. I have added everything to picture.
I am using MS SQL 2005
(Sorry about my english)
Note: The result of the query shall look like this:
ID2___Count_____Count of ID2 with Option=1_____Count of ID2 withOption=2
1_____5_________3___________________________2
2_____4_________0___________________________0
3_____6_________1___________________________2
4_____4_________2___________________________1
Thanks for every kind of help
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|