Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 20501 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 nosql db?
When are we going to use truncate and delete?
What is difference between joins and union?
Define tables and fields in a database
What are reports usually used for?
How can the performance of a trigger be improved?
Why should I use postgresql?
How to Declare Fixed Length String Value In PL SQL
what is the difference between $message and $$message? : Sql dba
how mysql optimizes distinct? : Sql dba
What is difference sql and mysql?
What is sql profiler in oracle?
What is sql catalog?
How do you rank data in sql?
Can we create table inside stored procedure?
