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
- 20639 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
What is the difference between pl and sql?
What are the various levels of constraints?
Explain architecture of sql server notification services?
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
What is a heap in sql?
What is a null value?
What are tables and fields in the database?
What are analytical functions in sql?
What is the maximum size of sqlite database?
Is keyword pl sql?
What trigger means?
How do you update f as m and m as f from the below table testtable?
How do you use join?
What is view? Can we update view
What is the difference between microsoft access and sql?
