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
- 18964 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / lova raju allumalla
select count(stud_name),course_name from student s,course c
where s.course_id = c.course_id group by course_name
/
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is a primary key? Explain
what is bcp? When does it used? : Sql dba
Which certification is best for sql?
What is the requirement of self-join?
What is database white box testing and black box testing?
What is pl sql in oracle?
how to use case expression? : Sql dba
How do sql databases work?
What is basic structure of pl sql?
What is the difference between a database and a relational database?
Can we call a function containing dml statements in a select query?
Explain the difference in execution of triggers and stored procedures?
What is a loop in sql?
what are myisam tables? : Sql dba
How does one use sql*loader to load images, sound clips and documents? : aql loader
