select s.stud_name,c.course_name from student s,course c where s.course

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

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

Answer Posted / cm

select s.stud_name,c.course_name from student s,course c
where s.course_id = c.course_id group by
s.stud_name,c.course_name;

Is This Answer Correct ?

1 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

State few characteristics of pl/sql?

1022

What is posting?

1083

What is function and procedure in pl sql?

1116

What is a subquery in sql?

1089

What is the location of pre_defined_functions.

1208

When can we use the where clause and the having clause?

1082

What is full join in sql?

1033

What is acid property in a database?

1086

How does postgresql compare to "nosql"?

1083

Explain autonomous transaction.

1220

What are all the different normalizations?

1078

Can we create foreign key without primary key?

1036

How do I trace sql profiler?

1042

Why is sql important?

1170

what are the advantages of sql ? : Sql dba

1105