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
- 20602 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 the sql commands?
Explain the difference between 'between' & 'and' operators in sql
What is rank dense_rank and partition in sql?
What is the use of sqldataadapter?
What are all the different normalizations?
How many types of literals are available in pl sql?
Are stored procedures faster than dynamic sql?
Will truncate release space?
Can we use ddl statements in stored procedure sql server?
What is insert command in sql?
what is 'trigger' in sql? : Sql dba
Can we call stored procedure in function?
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
How do you write a subquery?
Can you sum a count in sql?
