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
- 20650 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
what is bcp? When is it used?
what is a field in a database ? : Sql dba
Explain scalar functions in sql?
Can instead of triggers be used to fire once for each statement on a view?
What will you get by the cursor attribute sql%found?
How do you write a subquery?
What is the difference between functions, procedures, and packages in pl/sql?
What is sql table?
Which is faster count (*) or count 1?
what are rollup and cube in t-sql? : Transact sql
Is sql a case sensitive language?
explain about mysql and its features. : Sql dba
Can procedure in package be overloaded?
What is trigger in sql?
Which is better join or inner query?
