SELECT 'No of students in class '+ CONVERT (VARCHAR,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 / soorai ganesh

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

Answer Posted / soorai ganesh

SELECT 'No of students in class '+ CONVERT
(VARCHAR,ClassName)+' : '+CONVERT(VARCHAR, COUNT(*)) FROM
students GROUP BY classname

Is This Answer Correct ?

21 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are sql servers used for?

1021

Is it safe to delete log files?

899

How will you make an attribute not process? : sql server analysis services, ssas

1064

Can foreign key be deleted?

904

How to turn off warning messages during php execution?

1019

Can we use where clause in union?

1043

What are the advantages of partitioning?

1083

Explain acid?

1055

What are the different editions available in sql server 2000?

1028

How column data types are determined in a view?

942

What are the three different part of rdl file explain them?

263

How to stop log file growing too big?

996

Does group by or order by come first?

935

How do I edit a stored procedure in sql server?

903

Give an example of SQL injection attack ?

986