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
- 20240 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
Can we perform dml on view?
What is difference between pls_integer and integer?
explain the difference between bool, tinyint and bit. : Sql dba
How do you update a value in sql?
explain normalization concept? : Sql dba
Can we delete column in sql?
Which column of the user triggers data dictionary view displays the database event that will fire the trigger?
What is relationship? How many types of relationship are there?
What is bulk compiling in pl/sql.?
Why are aggregate functions called so?
How do you run a query?
What is program debugging?
How to run sql statements with oracle sql developer?
can sql servers linked to other servers like oracle? : Sql dba
What is trigger in flip flop?
