Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 20593 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / kalyan
SELECT COURSE_NAME,COUNT(B.STUDENT_ID) NO_OF_STUDENTS
FROM COURSE A LEFT OUTER JOIN STUDENT B
USING (COURSE_ID)
GROUP BY A.COURSE_NAME
OR
SELECT COURSE_NAME,COUNT(B.STUDENT_ID) NO_OF_STUDENTS
FROM COURSE A , STUDENT B
WHERE A.COURSE_ID = B.COURSE_ID(+)
GROUP BY A.COURSE_NAME
This will list all the courses with no of students
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
What does desc stand for?
How do you modify a table in sql?
Can a composite key be null?
Write a sql query to convert all character to uppercase after hypen.
What is the difference between partitioning and sharding?
What are the main features of cursor?
how to add a new column to an existing table in mysql? : Sql dba
What is primary key sql?
Explain the purpose of %type and %rowtype data types with the example?
how mysql optimizes distinct? : Sql dba
what is a database transaction? : Sql dba
What are the subsets of sql?
What is an exception in pl/sql?
How do I count records in sql?
Is truncate ddl or dml?
