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
- 17593 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / guest
select count(student_id),course_name ,student_name
from student s, course c
where s.course_id = c.course_id
group by course_id
order by student_id desc
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
what is unique key constraint? : Sql dba
what is clause? : Sql dba
What are functions in sql?
how to dump a table to a file with 'mysqldump'? : Sql dba
What is sql*loader and what is it used for?
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
Mention what does plv msg allows you to do?
What are the two types of exceptions in pl/sql?
What is the main reason behind using an index?
How many sql are there?
What is basic structure of pl sql?
What are sql injection vulnerabilities?
Can we insert data into materialized view?
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
How do I run a sql script?
