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 do you find value of first column before inserting value into the second column in the same table for checking that second column must have different value than first column.

2 Answers   L&T,

what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

0 Answers  

Define Unique Key?

0 Answers   HCL,

Let us say the SQL Server crashed and you are rebuilding the databases including the master database what procedure to you follow?

2 Answers  

What is in place upgrade in sql server?

0 Answers  




What is cursors? And what are the different types of cursor?

0 Answers  

what is normalization? Explain different levels of normalization? : Sql server database administration

0 Answers  

can we give the identity for existing column of the table? (already table contains 10(1-10) unique randam records)

2 Answers  

What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas

0 Answers  

explain different types of jions with examples briefly?

2 Answers   Accenture, Excellence, Zensar,

what is raid? : Sql server database administration

0 Answers  

Do you know clustered and non-clustered index?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories