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.
Answer Posted / chinnu
SELECT *(Courses,students) FROM Table Student
| Is This Answer Correct ? | 3 Yes | 14 No |
Post New Answer View All Answers
What is an invalid partition table?
How do I partition in sql?
How does rowid help in running a query faster?
How we can update the view?
Which query operators in sql is used for pattern matching?
What operating systems are supported by oracle sql developer?
What does pl sql developer do?
What is sql rowcount?
What is database white box testing and black box testing?
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
Where is all the data on the internet stored?
What is time based sql injection?
What are field types?
What are the built in functions of sql?
Who developed sql?