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
- 20221 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / neo28
select Course_Id, Course_Name, count(Student_id) from
(
select c.Course_Id, c.Course_Name, s.Student_id
from Student s, Course c
where s.Course_Id(+) = c.Course_Id
) group by Course_Id
order by Course_Id;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How many types of indexes are there in sql?
Is truncate ddl or dml?
How does a self join work?
What is relationship? How many types of relationship are there?
what are the drivers in mysql? : Sql dba
what is a cursor? : Sql dba
What is the difference between the implicit and explicit cursors?
what are the nonstandard string types? : Sql dba
How to get each name only once from an employee table?
what does the t-sql command ident_incr does? : Transact sql
Is stored procedure faster than query?
What do you mean by field in sql?
What is ttitle and btitle?
What is pessimistic concurrency control? : Transact sql
Which nosql database is best?
