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
- 18278 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 is a scheduled jobs or what is a scheduled tasks? : Sql dba
what is the difference between rownum pseudo column and row_number() function? : Sql dba
Mention what is the function that is used to transfer a pl/sql table log to a database table?
Is ms sql is free?
what is auto increment? : Sql dba
How we can update the view?
how to create a new table by selecting rows from another table in mysql? : Sql dba
What are primary key and foreign key and how they work?
What is the command used to fetch the first 5 characters of a string?
What is the mutating table and constraining table?
What is spool?
Why plvtab is considered as the easiest way to access the pl/sql table?
What is union?
Can we create foreign key without primary key?
How global cursor can be declare with dynamic trigger ?
