select course_id,count(*) from student where course_id in (select course

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.

Question Posted / dinakar

10 Answers
20238 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

Please Help Members By Posting Answers For Below Questions

Is sql better than excel?

1059

Is there a 64 bit version of ssms?

893

What is relationship? How many types of relationship are there?

1070

What are the query optimization techniques?

885

How do you rename a table in sql?

1027

what is the functionality of the function htmlentities? : Sql dba

890

What is t-sql? : Transact sql

925

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

1175

1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

1536

What is a schema? How is it useful in sql servers?

1041

What is sql clause?

992

Can we use distinct and group by together?

989

Why coalesce is used in sql?

916

What is a temporal data type?

978

What are tables and fields?

973