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 / samba shiva reddy . m

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

Answer Posted / samba shiva reddy . m

select 'No of students in class '+ CONVERT(VARCHAR,ClassName)+' : '+ convert(varchar,Count(studname)) from students
group by
classname order by classname

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the authentication modes in sql server? How can it be changed?

1132

Is it important for a database administrator to understand the operating system and file access?

1002

Is ssrs support other database except ms sql server?

142

Define candidate key, alternate key, and composite key.

926

Explain how many normalization forms?

1037

What are the difference between data mart and data warehouse? : sql server analysis services, ssas

965

What is an execution plan? When would you use it?

980

what kind of lan types do you know? : Sql server database administration

981

How do I shrink an ldf file?

981

What are horizontal and vertical scaling?

172

How to set the current database in ms sql server?

1089

What is the difference between primary key and unique constraints?

966

What is the default server name for sql server?

1177

How much does sql server 2016 cost?

1076

How do I start and stop sql server?

1028