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
- 17599 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 your daily office routine?
explain the options of myisamchk to improve the performance of a table. : Sql dba
what is the difference between a web-garden and a web-farm? : Sql dba
Why select is used in sql?
Is sql port 1433 encrypted?
what is 'mysqld'? : Sql dba
What is having clause in sql?
What is scalar function?
What is the difference between union and union all command?
how can we destroy the session, how can we unset the variable of a session? : Sql dba
Can there be more than one function with a similar name in a pl/sql block?
How do I save a sql query?
What is difference between joins and union?
What are different types of functions in sql?
What is a sql profiler?
