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
- 17671 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / lova raju allumalla
select count(stud_name),course_name from student s,course c
where s.course_id = c.course_id group by course_name
/
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is the difference between a primary key and a clustered index?
What are the different datatypes available in PL/SQL?
What does count (*) mean in sql?
what is top in tsql? : Transact sql
How to sort the rows in sql.
Where is pl sql used?
What is Difference Between Unique and Primary Key Constraints?
Is sql a backend language?
How do you optimize a query?
Can we edit a view in sql?
Is sql workbench free?
What does subquery mean in sql?
What are the types of operators available in sql?
What is rank function in sql?
What is composite primary key in sql?
