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
- 18966 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / pradip d
select count(student_name),course_name from student,course
where course.course_id=student.course_id group by course_name;
| Is This Answer Correct ? | 18 Yes | 8 No |
Post New Answer View All Answers
What is composite primary key in sql?
Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?
What is transaction control language (tcl)?
What are the benefits of pl sql?
Is oracle and sql same?
What is pl sql in dbms?
How many tables can a sql database have?
explain commit and rollback in mysql : sql dba
What is pls integer?
What is the location of pre_defined_functions.
Explain the significance of the & and && operators in pl sql.
How is pl sql different from sql?
What will you get by the cursor attribute sql%found?
How much does sql cost?
Do ddl statements need commit?
