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
- 18275 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
what are the differences between char and varchar? : Sql dba
how to enter binary numbers in sql statements? : Sql dba
What are the types of functions in sql?
What is the difference between delete and truncate commands?
What is output spooling in sql*plus?
What are the two types of periodical indexes?
How to use sql statements in pl/sql?
Explain alias in sql?
what is the difference between join and union? : Sql dba
Is a view faster than a stored procedure?
What does the file extension accdb stand for?
Is a foreign key always unique?
How do you update sql?
What is difference between procedure and trigger?
What is java sql connection?
