Consider the following table structure of students:
rollno int
name varchar(20)
course varchar(20)
What will be the query to display the courses in which the number of students enrolled is more than 5?
Correct Answer: Select course from students group by course having count(*) > 5;
Explanation:
Note: This Question is unanswered, help us to find answer for this one
More ASP.NET With SQL Server MCQ Questions
ASP.NET With SQL Server MCQs | Topic-wise