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
- 18981 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
How do I order by ascending in sql?
Is natural join same as inner join?
What is pl sql package?
What is pl sql architecture?
what is the difference between nested subquery and correlated subquery?
What is sql resultset?
How do you write an inner join query?
Is it possible to create the following trigger: before or after update trigger for each row?
Why trigger is used in sql?
What is on delete restrict?
what are the authentication modes in sql server? : Sql dba
What is application trigger?
What are the built in functions of sql?
How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?
define sql insert statement ? : Sql dba
