select count(student_id),course_name ,student

Table Student has 3 columns,Student_id,Student_Name &
Course_Id. Table Course has 2 columns, Course_Id &
Course_Name.Write a query to listdown all the Courses and
number of student in each course.

Question Posted / guest

10 Answers
20651 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / guest

select count(student_id),course_name ,student_name
from student s, course c
where s.course_id = c.course_id
group by course_id
order by student_id desc

Is This Answer Correct ?

2 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are data types in pl sql?

1146

Is subquery faster than join?

1018

what is data integrity? : Sql dba

1040

What is mutating error in pl sql?

1023

what are the different functions in sorting an array? : Sql dba

1027

in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

2085

What do you mean by table in sql?

996

what are the properties and different types of sub-queries? : Sql dba

1035

How many types of functions are there in sql?

955

What are the different types of dbmss?

1015

What does the sign mean in sql?

993

What are conditional predicates?

1064

What are the types of dbms?

975

Can we join more than 2 tables in sql?

1024

What is the unique index?

1055