MCQs>IT & Programming>Microsoft SQL Server>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?
Microsoft SQL Server MCQs
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?
Answer
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