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.
- 10 Answers
- 18967 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / iamanocp
select c.course_id, count(s.student_id)
from student s, course c
where s.course_id = c.course_id
group by c.course_id;
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Which join is default?
What is procedure and function in sql?
What are its different types of dbms?
Show how functions and procedures are called in a pl/sql block.
Enlist some predefined exceptions?
What is the difference between clustered and non-clustered indexes?
What is difference between pl and sql?
What are the different types of triggers?
what is normalization? : Sql dba
What is character functions?
how many ways to get the current time? : Sql dba
How do you define a foreign key?
What are character functions?
What is the use of function "module procedure" in pl/sql?
Which table is left in left join?
