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
- 20603 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / guest
select count(student_id),course_name ,student_name
from student s, course c
where s.course_id = c.course_id
group by course_id
order by student_id desc
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
What are stored procedures in mysql?
What is sql table?
What is a join?
What is parameter substitution in sql?
What is difference between rank () row_number () and dense_rank () in sql?
Explain dml and ddl?
What are the two types of exceptions in pl/sql?
What are the types of records?
How is a process of pl/sql compiled?
What are aggregate and scalar functions?
What is the difference between null value, zero, and blank space?
What is procedure and function?
Which are the different case manipulation functions in sql?
how many triggers are allowed in mysql table? : Sql dba
How do I audit the sql sent to the server?
