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
- 20919 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 does 0 mean in sql?
what is 'mysqlshow'? : Sql dba
What is keys and its types?
Explain the select statement in sql?
What is 19 null in sql?
Does oracle use sql?
How do I install microsoft sql?
What is difference between rank () row_number () and dense_rank () in sql?
How many row comparison operators are used while working with a subquery?
What is procedure and function in sql?
Can we use two order by clause in query?
where are cookies actually stored on the hard disk? : Sql dba
What are types of indexes in sql?
Can we insert data into materialized view?
Explain what is a subquery ?
