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
- 17715 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
What is materialized view. What are different methods of refresh?
how to use case expression? : Sql dba
what is the difference between blob and text? : Sql dba
How many primary keys can a table have?
how to dump a table to a file with 'mysqldump'? : Sql dba
What is sql indexing?
What is the use of function "module procedure" in pl/sql?
What are expressions?
What is nosql example?
what is the difference between union and union all? : Sql dba
What are variables in pl sql?
How can use stored procedures in sql?
How do you update a table in sql?
Differentiate between sga and pga.
Are stored procedures faster than dynamic sql?
