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
- 17710 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
What can I use instead of union in sql?
Is sql sequential or random?
What is right join sql?
How do I remove duplicates in two columns?
What are pl/sql cursors?
What are the types of optimization?
What is an implicit commit?
Explain isolation levels. : Transact sql
Is sql injection illegal?
What is the difference between a procedure and a function?
How to add a column ‘salary’ to a table employee_details?
Explain normalization and what are the advantages of it?
Which is faster view or stored procedure?
How many types of privileges are available in sql?
Is big data nosql?
