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
- 18277 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
Can we use views in stored procedure?
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
What is cartesian join in sql?
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
Is left join faster than inner join?
What is a scalar value in sql?
What's the difference between a primary key and a clustered index?
What is ttitle and btitle?
What does inner join mean?
What is index example?
Are subqueries faster than joins?
How to write pl sql program in mysql command prompt?
What is sqlerrd?
what is data manipulation language? : Sql dba
What is trigger explain with example?
