1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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 / klbaiju

Answers were Sorted based on User's Feedback



i have table students with fields classname,studname select * from students classname studname 1..

Answer / 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

i have table students with fields classname,studname select * from students classname studname 1..

Answer / debasish

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

Is This Answer Correct ?    2 Yes 1 No

i have table students with fields classname,studname select * from students classname studname 1..

Answer / ramadass

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

Is This Answer Correct ?    1 Yes 0 No

i have table students with fields classname,studname select * from students classname studname 1..

Answer / 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

i have table students with fields classname,studname select * from students classname studname 1..

Answer / manoj pandey

select 'No of students in class ' + cast(classname as char(2)) + ' : ' + cast(count(*) as char(5)' from students group by classname


For more Interview Questions check my blog: http://sqlwithmanoj.wordpress.com/interview-questions/

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

How to delete duplicate records based on single column from a table?

0 Answers   Petranics Solutions,

how to copy sysdatabase file from c: Drive to D: Drive in SQL Server.

6 Answers   IBM,

How to download and install microsoft sql server management studio express?

0 Answers  

How to display a past time in days, hours and minutes?

0 Answers  

What is the use of DBCC commands?

4 Answers   NA,




How to delete existing rows in a table?

0 Answers  

what is create database syntax? : Sql server database administration

0 Answers  

What is similarity and difference between truncate and delete in sql?

0 Answers  

What are the advantages of sql stored procedure?

0 Answers  

What is data source document?

0 Answers  

What is user defined stored procedures?

0 Answers  

to explain sql server 2000 architecture & authentication

1 Answers   HCL,

For more SQL Server Interview Questions Click Here
Categories