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
- 17611 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / neo28
select Course_Id, Course_Name, count(Student_id) from
(
select c.Course_Id, c.Course_Name, s.Student_id
from Student s, Course c
where s.Course_Id(+) = c.Course_Id
) group by Course_Id
order by Course_Id;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Define select, insert, create, delete, update, drop keywords
Why do we use subquery?
Is sql the best database?
Why commit is not used in triggers?
How do I make my sql query run faster?
Which are sql * plus commands?
What is application trigger?
Is stored procedure faster than query?
What are the constraints available in sql?
Which is the correct statement about truncate and delete?
What is pessimistic concurrency control? : Transact sql
What is rowtype?
What are stored procedures in mysql?
Can we alter stored procedure?
Explain the working of primary key?
