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
- 20502 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / monalisa.dalbehera
select count(s.student_id),c.cource_name
from student s,course c
where c.course_id=s.course_id
group by c.course_name;
| Is This Answer Correct ? | 48 Yes | 3 No |
Post New Answer View All Answers
How do I add a primary key to a table?
What does desc stand for?
Why we use joins in sql?
Which is better varchar or nvarchar?
Why do we use triggers?
What is sql and explain its components?
What are properties of the transaction?
Can a view be mutating? If yes, then how?
How to run sql statements through the web interface?
What is the difference between rename and alias?
What is microsoft t sql?
How to call a javascript function from pl sql?
Can we commit in trigger?
what are all the different types of indexes? : Sql dba
how to dump a table to a file with 'mysqldump'? : Sql dba
