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
- 20917 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 to get a list of indexes of an existing table? : Sql dba
What is the max nvarchar size?
what happens if you no create privilege in a database? : Sql dba
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
how can we repair a mysql table? : Sql dba
Explain what is a column in a table?
Why do we use joins?
Is it possible to include an insert statement on the same table to which the trigger is assigned?
What is a sql profiler?
How you improve the performance of sql*loader? : aql loader
What is a clob in sql?
What is the difference between nested table and varray?
Does a user_objects view have an entry for a trigger?
what is the difference between cluster and non cluster index? : Sql dba
What is anonymous block in sql?
