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
- 17595 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 a recursive stored procedure?
how can you create an empty table from an existing table? : Sql dba
what is query cache in mysql? : Sql dba
Explain the uses of control file.
Is a foreign key always unique?
How do you optimize a stored procedure query?
What is cold data?
Name three sql operations that perform a sort.
How would you reference column values before and after you have inserted and deleted triggers?
What is cte?
What are the types of sql commands?
What is a pdo connection?
Is inner join faster than left join?
How do you update f as m and m as f from the below table testtable?
Is it important to partition hard disk?
