SELECT *(Courses,students) FROM Table Student

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.

Question Posted / chinnu

10 Answers
20635 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

Please Help Members By Posting Answers For Below Questions

What is embedded sql with example?

1049

what are the disadvantages of mysql? : Sql dba

1149

how to include comments in sql statements? : Sql dba

955

Can we debug stored procedure?

1024

how to fetch alternate records from a table? : Sql dba

1112

What is the requirement of self-join?

1132

how to write date and time literals? : Sql dba

959

How do I run a sql script?

1146

What is thread join () in threading?

1015

What are the three forms of normalization?

1045

How do you delete a table?

1074

What is sql mysql pl sql oracle?

1070

What are character functions?

1087

what is data manipulation language? : Sql dba

1016

What is the use of <> sql?

980