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
- 20648 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
Is mariadb a nosql database?
what is table? : Sql dba
What does the sign mean in sql?
What is clause in sql?
What is trigger in flip flop?
How many rows can sqlite handle?
How do you know if a relationship is 2nf?
Can we create table in function?
How do I save the results of sql query in a file?
What is a database trigger?
How to change sql*plus system settings?
what does myisamchk do? : Sql dba
How to use distinct and count in sql query? Explain
What is varchar example?
Can we rename a column in the output of sql query?
