Which of the following MySQL query is syntactically correct and most preferred…
PYQ EMRS TGT/PGT (ESSE) 2023
Which of the following MySQL query is syntactically correct and most preferred one?
- A.
SELECT SECTION, COUNT(*) FROM STUDENT
ORDER BY SECTION
GROUP BY SECTION
WHERE MARKS < 33 AND COUNT(*) > 0;
- B.
SELECT SECTION, COUNT(*) FROM STUDENT
WHERE MARKS < 33
HAVING COUNT(*) > 0
GROUP BY SECTION
ORDER BY SECTION;
- C.
SELECT SECTION, COUNT(*) FROM STUDENT
WHERE MARKS < 33
GROUP BY SECTION
HAVING COUNT(*) > 0
ORDER BY SECTION;
- D.
SELECT SECTION, COUNT(*) FROM STUDENT
GROUP BY SECTION
WHERE MARKS < 33 AND COUNT(*) > 0
ORDER BY SECTION;
Attempted by 2323 students.
Sign up free to check your answer
Sign up freeLoading lesson…

