count(*) for Per-Group

[sql]

I need to cross join on three tables, and need to found the count(*) for per Croup and the total number for all group , what menthod I can use ,
Thank you!
________
Daihatsu

[skhanal]

Use GROUP BY clause.

[sql]

is that possible to group by InterviewDate and the InterviewDate
may be 'yyyy-mm-dd' ( default) or any date the formats like '2010-01-26 '
thank you!
________
LAMBORGHINI LM003 HISTORY

[skhanal]

You can, use

GROUP BY CONVERT(interviewdate,char(10),105)

This will group by dd-mm-yyyy

[sql]

I want to count for all , also want the count for those interview is not yyyy-mm-dd(actually have date in the column) is that possible too?
Thank you
________
Bmw X

[skhanal]

I am not clear on what you are trying to get. Can you post sample data and result you want. You can't get two types of count with one statement.