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
- 20503 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 stored procedure faster than query?
How can use stored procedures in sql?
How to pronounce postgresql?
How to write pl sql program in mysql command prompt?
Where do we use pl sql?
What is a sql trace file?
How do you know if a relationship is 2nf?
How is use pl and sql?
What is localdb mssqllocaldb?
what does it mean to have quoted_identifier on? : Sql dba
What is form and report?
What is the difference between inner join and natural join?
What is replication id?
How do I edit a trigger in sql developer?
How do I remove sql developer from windows 10?
