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
20220 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 dba in sql? : SQL DBA

993

What are triggers in sql?

970

What are three advantages to using sql?

958

What are all different types of collation sensitivity?

973

How to Execute a Package in PL/SQL.?

1106

Why is the cursor important?

972

what is a field in a database ? : Sql dba

986

How does postgresql compare to "nosql"?

980

define join and explain different type of joins? : Sql dba

897

Can a view be mutating? If yes, then how?

956

what is innodb? : Sql dba

1028

How do I install microsoft sql?

974

What are pl/sql packages?

1035

how are mysql timestamps seen to a user? : Sql dba

1044

Define join and name different types of joins?

955