bringing a particular value

[saina]

Hello,
I am kinda beginner in sql. I have to bring teh rows of particular value .
I have a table which has column where the values X or Y.I need to bring count of the rows which has value X.

Thanks for your help

 

[r937]

see 12.10.1 GROUP BY (Aggregate) Functions

r937.com | rudy.ca

 

[saina]

My query is
a.name,b.title,b.sex from tbl a,tbl b where b.title in('Manager','General Manger') group by a.name,b.title

i need to bring rows which has count of female population who hold a particular title and also count of male population who hold a particular title.

like count of managers who are female is 20 and count of general managers who are male is 15 and column b.sex has values F,M

it will be helpfull if someone can help

 

[r937]

check that link i gave you, and look for the COUNT() function

also, you will need to learn how to write a proper join

search in google for "sql table join syntax"

it seems that you are really very new to SQL in general, so you should take a tutorial first

r937.com | rudy.ca