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
20915 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

How do I order by ascending in sql?

1078

How do I order columns in sql?

1071

How to run sql*plus commands in sql developer?

1206

What are the types of variables use in pl sql?

1089

What is cursor in pl sql?

1185

what is top in tsql? : Transact sql

1171

how to calculate expressions with sql statements? : Sql dba

1094

Mention what is the function that is used to transfer a pl/sql table log to a database table?

1032

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

7480

How to run pl/sql statements in sql*plus?

1143

What are triggers in sql?

1059

How to read/write files from pl/sql?

1083

What are the 3 modes of parameter?

1204

How many disk partitions should I have?

1040

What is difference between procedure and trigger?

1020