[2005] Which command?

I am tring to make a query but I am a beginner in SQL commands. Example is following:
http://img297.imageshack.us/img297/5...mpletp3.th.png
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)

Thanks for every kind of help

The smart tags in VB2005 make it very easy to generate SQL statements. If you could give us a better idea of what you're after, then we can help you with a specific task...

Quote:

---

If you could give us a better idea of what you're after, then we can help you with a specific task...

---

Sorry I dont understand that phrase?

What exactly do you need to accomplish?

select count(ID2) from mytablename

i added that in picture:
I want to see in my datagrid view:

ID2* | Count of rows with ID2 | Count of rows with option=1 | Count of rows with option=2

* There are lots of ID2 values and I will use "DISTINCT" to see only one ID2 per 1 row

Command will be like this:
SELECT ID2 DISTINCT,Count(......),COUNT(.......),COUNT(.......) From Table

As for the other query:

select count(*) from tablename where option = 1

SQL's not complicated. I suggest you invest some time in a tutorial.

yeah I know w3school tutorials and I know that SQL is not complicated I learned it alone from that website but the code which you have written gives me only one integer. But I want rows...
SELECT ID2 DISTINCT,Count(......),COUNT(.......),COUNT(.......) From Table
in this code there are 4 columns. I cant use count function as a column how can I do that?

This shall be shown in Datagridview
ID2___Count_____ID2 with Option=1_____ID2 with Option=2
1_____5_________3___________________2
2_____4_________0___________________0
3_____6_________1___________________2
4_____4_________2___________________1
How to do this with SQL?

noone knows?

Writing SQL queries has nothing to do with VB.NET, even if they're being executed from a VB.NET application. SQL is database programming and therefore questions regarding it belong in the Database Development forum.