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
- 20243 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / cm
select s.stud_name,c.course_name from student s,course c
where s.course_id = c.course_id group by
s.stud_name,c.course_name;
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
what are rollup and cube in t-sql? : Transact sql
what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba
What are the parameter modes supported by pl/sql?
Explain the difference between drop and truncate commands in sql?
What is sql constant?
How to use distinct and count in sql query? Explain
Which one is better sql or oracle?
What is keys and its types?
What is primary key and foreign key with example?
What are the advantages of stored procedure?
What is string data type in sql?
What is sql exception?
How do you pronounce sql?
What is cursor explain with example?
how many sql dml commands are supported by 'mysql'? : Sql dba
