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
- 18266 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / guest
select count(student_id),course_name ,student_name
from student s, course c
where s.course_id = c.course_id
group by course_id
order by student_id desc
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
How to order siblings in oracle hierarchy queries?
Can we create table in function?
Is sql a microsoft product?
What is the importance of sqlcode and sqlerrm?
What is a constraint?
What is forward declaration in pl sql?
what is acid property in database? : Sql dba
what is a primary key? : Sql dba
Does truncate require commit?
What is sap sql?
How do I copy a table in sql?
What is the use of desc in sql?
how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba
Show the two pl/sql cursor exceptions.
Can I learn sql in a week?
