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
- 18279 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 a database transaction? : Sql dba
How to write html code in pl sql?
what is a unique key ? : Sql dba
What are the benefits of pl/sql packages?
Does sql full backup truncate logs?
What is clause in sql?
how to create a test table in your mysql server? : Sql dba
what is bcp? When is it used?
How do temporal tables work?
What is nvarchar in sql?
Which one is faster ienumerable or iqueryable?
Is left join and outer join same?
Can we enter data in a table in design view?
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
What is difference between rank () row_number () and dense_rank () in sql?
