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
- 20597 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / pradip d
select count(student_name),course_name from student,course
where course.course_id=student.course_id group by course_name;
| Is This Answer Correct ? | 18 Yes | 8 No |
Post New Answer View All Answers
What is cursor and why it is required?
How insert into statements in sql?
Why is sql important?
How do I remove sql developer from windows 10?
Explain unique key in sql.
Do stored procedures prevent sql injection?
tell us something about heap tables. : Sql dba
what is cross join? : Sql dba
What is procedure explain with program?
what is data control language? : Sql dba
Which nosql database is best?
What is the sql query to display the current date?
Is primary key a clustered index?
Can %notfound return null after a fetch?
How many sql core licenses do I need?
