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
- 18979 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 default isolation level in sql server? : Transact sql
How can you select unique records from a table?
How can you get sql*loader to commit only at the end of the load file? : aql loader
Is it possible to sort a column using a column alias?
What is the maximum size of sqlite database?
What are some emotional triggers?
What are the popular database management systems in the it industry?
How can I tell if sql is running?
Does normalization improve performance?
How to raise user-defined exception with custom sqlerrm ?
Can you selectively load only those records that you need? : aql loader
What is sql comments?
Are left and right joins the same?
What is the non-clustered index in sql?
what are numeric data types? : Sql dba
