select classname,count(studentname) from students group by classname

i have table students with fields classname,studname
select * from students
classname studname
1 xxxxx
1 yyyy
1 zzzz
2 qqqq
2 tttt
3 dsds
3 www
i want the output should be

No of students in class 1 : 3
No of students in class 2 : 2
No of students in class 3 : 2

Question Posted / debasish

5 Answers
10090 Views
HCL, ZX, I also Faced
E-Mail Answers

Answer Posted / debasish

select classname,count(studentname) from students group by
classname

Is This Answer Correct ?

2 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to enable/disable indexes?

1123

What are the approximate numeric data types?

988

What are different types of data sources?

1084

What are entities and relationships?

1024

Which is better statement or preparedstatement?

984

how to take backup bcp out for a column in table in sql server?

2144

what's the information that can be stored inside a bit column? : Sql server database administration

1087

can we have a nested transaction? : Sql server database administration

1193

How to round a numeric value to a specific precision?

1126

Explain important index characteristics?

1077

How to list all login names on the ms sql server?

1185

After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas

1010

How to connect to a sql server using odbc_connect()?

1204

How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

1247

What is intellisense?

1101