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
- 20497 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / guest
select count(student_id),course_name ,student_name
from student s, course c
where s.course_id = c.course_id
group by course_id
order by student_id desc
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
Can we call procedure in select statement?
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
What happens when a trigger is associated to a view?
How do I install microsoft sql?
What is trigger with example?
What are the two virtual tables available at the time of database trigger execution?
What are the types of subqueries?
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
how to present a past time in hours, minutes and seconds? : Sql dba
What is sap sql anywhere?
what is a relationship and what are they? : Sql dba
How do I edit a stored procedure?
What type of database is sql?
What is the example of procedure?
Is sql better than excel?
