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
- 20918 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / pradip d
select count(student_name),course_name from student,course
where course.course_id=student.course_id group by course_name;
| Is This Answer Correct ? | 18 Yes | 8 No |
Post New Answer View All Answers
What does select * from mean in sql?
Can %notfound return null after a fetch?
What is sql injection owasp?
Why is sharding used?
Is left join and outer join same?
What is trigger types in sql?
Is primary key is clustered index?
How can a pl sql block be executed?
What is trigger and stored procedure in sql?
How do I turn a list into a table?
How do you optimize a stored procedure query?
What are all the different normalizations?
What is package in pl sql with an examples?
How do you declare a user-defined exception?
What is an implicit commit?
