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
- 17716 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / dinakar
select course_id,count(*) from student where course_id in
(select course_id From course)
GROUP BY COURSE_ID
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
Does view store data in sql?
Define commit, rollback and savepoint?
What is rtm stands for?
What is the maximum size of sqlite database?
Where do we use pl sql?
Explain the components of sql?
How do I restart sql?
What is parallel hint?
List out the acid properties and explain?
What is the use of stored procedures?
How does postgresql compare to oracle/db2/ms sql server/informix?
What do you know by pl/sql cursors?
What is trigger in sql and its types?
Can we commit in trigger?
How to add new employee details in an employee_details table with the following details
