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
- 17663 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 difference between stored procedures and application procedures?
Can we perform dml in function?
What is the difference between cross join and natural join?
Is join an inner join?
What is pivot in sql?
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
what is the difference between join and union? : Sql dba
Name three sql operations that perform a sort.
Is it possible for a table to have more than one foreign key?
what are the advantages of using stored procedures? : Sql dba
What are joins in sql?
What are the advantages of pl sql?
What is the starting oracle error number? What is meant by forward declaration in functions?
What is offset in sql query?
How many primary keys can a table have?
