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
- 17672 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
Where the sql database files are stored?
Is subquery faster than join?
What is difference between primary and secondary key?
How do you concatenate in sql?
What is the difference between having clause and where clause?
What is trigger with example?
What is pls integer?
what is text? : Sql dba
Does truncate remove indexes?
How do you modify a table in sql?
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
What is insert command in sql?
Compare sql & pl/sql
What is the difference between delete and truncate statement in sql?
What is sql prepared statement?
