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
- 20229 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
What is a schema sql?
How to know the last executed procedure?
Is oracle and sql same?
what is union? : Sql dba
what are the performance and scalability characteristics of mysql? : Sql dba
Write a sql select query that only returns each name only once from a table?
Does inner join return duplicate rows?
What are the built in functions of sql?
What is a native sql query?
Can we use ddl commands in pl sql?
How to call shell script from pl sql procedure?
Do foreign keys improve performance?
What is trigger in sql? Explain
What does an inner join do?
Can we use ddl statements in stored procedure sql server?
