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
- 20492 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / lova raju allumalla
select count(stud_name),course_name from student s,course c
where s.course_id = c.course_id group by course_name
/
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Why partition by is used in sql?
How do you sort in sql?
Explain what is an index?
How to raise user-defined exception with custom sqlerrm ?
What is rollback?
how many ways to get the current time? : Sql dba
What are the rules to be applied to nulls whilst doing comparisons?
What is the difference between cross join and natural join?
What are types of indexes in sql?
Write a sql query to find the names of employees that begin with ‘a’?
How many types of indexes are there in sql?
What are the three pl sql block types?
How do I run a pl sql procedure in sql developer?
What are the advantages of indexing?
How to pipe multiline string to isql?
