Forum

Write a Query to Di...
 
Share:
Notifications
Clear all

Write a Query to Display the Course Name Registered by at least two Students. Sort the results based on Course Name.


Posts: 17
Topic starter
(@rahul)
Active Member
Joined: 4 years ago

Write a query to display the course name registered by at least two students.  Sort the results based on Course Name.

1 Reply
Posts: 27
Admin
(@vinodkrsetty)
Eminent Member
Joined: 6 years ago

Hi Rahul,

I hope this query will give you the expected output. Please check and let me know

Select a.CourseName,b.FirstName,
c.Count(CourseID)
From
Course a,
Student b,
Registration c
group by a.CourseName, b.FirstName
Having Count(CourseID)=>2
Order by Course_Name DESC

 
Reply

Self Learning Video Tutorials - Software Course

Leave a reply

Author Name

Author Email

Title *

 
Preview 0 Revisions Saved
Share: