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
- 20627 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
What is hibernate and its relation to sql?
What plvcmt and plvrb does in pl/sql?
Which is faster view or stored procedure?
How do I create a sql script?
Can you load data into multiple tables at once? : aql loader
what is a trigger in mysql? Define different types of trigger. : Sql dba
How is use pl and sql?
How to get each name only once from an employee table?
What is the difference between sql and mysql?
What are types of indexes in sql?
What operators deal with null?
Is natural join and inner join same?
What does trigger mean in psychology?
What are the different sql languages?
Why do we go for stored procedures?
