Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 20493 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
What is the difference between function, procedure and package in pl/sql?
Is a table valued function object?
How to avoid using cursors?
Why do we need pl sql?
What are sql constraints?
Can we rollback delete command?
What are inner and outer joins examples of both?
how to return query output in html format? : Sql dba
What are the differences between in and exists clause?
Is sqlexception checked or unchecked?
Explain exception handling in pl/sql?
What is the current version of postgresql?
What is the difference between local variables and global variables?
what are date and time data types? : Sql dba
How can I delete duplicate rows?
