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
- 20911 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / iamanocp
select c.course_id, count(s.student_id)
from student s, course c
where s.course_id = c.course_id
group by c.course_id;
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is the current version of postgresql?
write an sql query to find names of employee start with 'a'? : Sql dba
What is record in pl sql?
What are the parts of a basic sql query?
What are pl/sql packages?
Why do we use procedures?
Which version of sql do I have?
What does the base_object_type column shows in the user.triggers data dictionary view?
Is sql pronounced sequel or sql?
What is sql injection owasp?
Can a table contain multiple foreign key’s?
What is partition in sql query?
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
What is normalization? How many normalization forms are there?
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
