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
- 20640 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 'mysqldump'? : Sql dba
What is trigger in sql? Explain
Does view contain data?
What is a variable in sql?
What are the types of subqueries?
How many databases can sql express handle?
What is the use of sqlerrd 3?
What is the difference between rollback and rollback to statements?
What program will open a mdb file?
Why do we use subquery?
Name the operator which is used in the query for pattern matching?
What is basic structure of pl sql?
how can we know the number of days between two given dates using mysql? : Sql dba
What is a sql trace file?
where are cookies actually stored on the hard disk? : Sql dba
