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
- 18965 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / cm
select s.stud_name,c.course_name from student s,course c
where s.course_id = c.course_id group by
s.stud_name,c.course_name;
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Why is the cursor important?
Mention what does the hierarchical profiler does?
what is the functionality of the function htmlentities? : Sql dba
How bulk collect improves performance?
How does sql profiler work?
What is a parameter query?
What are the types of join and explain each?
What are the methods of filing?
Is t sql a programming language?
What is sqlservr exe?
what are the security recommendations while using mysql? : Sql dba
What are different types of keys?
What is the benefit of foreign key?
Is json a nosql?
What is hibernate and its relation to sql?
