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
- 17600 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
Why indexing is needed?
explain the difference between delete , truncate and drop commands? : Sql dba
what is the difference between union and union all? : Sql dba
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
What is inner join in sql?
What are the string functions in sql?
How will you distinguish a global variable with a local variable in pl/sql?
How to run sql*plus commands in sql developer?
Why should I use postgresql?
What are some predefined exceptions in pl/sql?
Is left join inner or outer?
what is column? : Sql dba
How do you delete duplicates in sql query using rowid?
What are the different types of joins in sql?
Can delete statement be rollbacked?
