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
- 20244 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 are the different types of dbms?
Is grant a ddl statement?
What is dynamic query?
Why use subqueries instead of joins?
Are null values same as that of zero or a blank space?
How to process query result in pl/sql?
Can we use insert statement in function?
How can you tell the difference between an index and a view?
Is sqlexception checked or unchecked?
How many postgresql users are there, worldwide?
Where do we use pl sql?
What is the difference between nvl function, ifnull function, and isnull function?
What is pivot in sql?
What does where 1 1 mean in sql?
Difference between global and parameter variables?
