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
- 17596 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / chinnu
SELECT *(Courses,students) FROM Table Student
| Is This Answer Correct ? | 3 Yes | 14 No |
Post New Answer View All Answers
Explain spool.
Why do we need view in sql?
How do I access sql anywhere database?
Can variables be used in sql statements?
How to check if a column is nullable before setting to nullable?
What is cte?
What is the maximum number of columns in sql table?
Difference between global and parameter variables?
What is %type in sql?
What is sqlca in db2?
What is embedded sql in db2?
Should I use mbr or gpt?
How to connect a sql*plus session to an oracle server?
What is recursive join in sql?
Where can I learn sql for free?
