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
- 20585 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
What is recursive stored procedure?
In pl/sql, what is bulk binding, and when/how would it help performance?
What is before and after trigger?
What is the example of procedure?
Explian rowid, rownum? What are the psoducolumns we have?
explain primary keys and auto increment fields in mysql : sql dba
What is offset in sql query?
What is the use of index in sql?
Does view contain data?
What are stored procedures used for?
What is sql used for?
what are tables and fields? : Sql dba
What is the difference between the repeatable read and serializable isolation levels? : Transact sql
Can instead of triggers be used to fire once for each statement on a view?
Can you do multiple joins in sql?
