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
- 17654 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / guest
select count(student_id),course_name ,student_name
from student s, course c
where s.course_id = c.course_id
group by course_id
order by student_id desc
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
Which are sql * plus commands?
Why is stored procedure faster than query?
Which are the different types of indexes in sql?
How do you delete duplicates in sql query using rowid?
What is difference between table and view?
What is nvarchar max in sql?
How do you update sql?
Differentiate between % rowtype and type record.
What is the reports view in oracle sql developer?
How do I truncate a word?
Is nosql relational?
how to install mysql? : Sql dba
What is sql deadlock?
how to start mysql server? : Sql dba
What are the different sql languages?
