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
- 17661 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / monalisa.dalbehera
select count(s.student_id),c.cource_name
from student s,course c
where c.course_id=s.course_id
group by c.course_name;
| Is This Answer Correct ? | 48 Yes | 3 No |
Post New Answer View All Answers
What is time based sql injection?
Can a procedure in a package be overloaded?
What is procedure explain with program?
how to rename an existing column in a table? : Sql dba
what is single byte over head in oracle..?
What are pl/sql packages?
What is sql prepared statement?
What are the triggers associated with image items?
What is a table partition?
What is pl sql commands?
what are the differences among rownum, rank and dense_rank? : Sql dba
How do I run sql?
What is implicit cursor in pl sql?
What is replication id?
how tsql statements can be written and submitted to the database engine? : Transact sql
