Question Practice

Which statement correctly uses the GROUP BY clause along with HAVING?

Attempt the question, check the explanation, and continue with similar questions to build confidence before exams.

MCQ_SA

Single Answer MCQ

Q-00095279

SELECT EmpID, SUM(SalePrice) FROM SALE GROUP BY EmpID HAVING SUM(SalePrice) > 500000;

SELECT EmpID, SUM(SalePrice) FROM SALE HAVING SUM(SalePrice) > 500000;

SELECT SUM(SalePrice) FROM SALE GROUP BY EmpID HAVING EmpID = 'E001';

SELECT EmpID, COUNT(*) FROM SALE WHERE Salary > 50000 GROUP BY EmpID;

Video Explanation

Watch Video Solution

Keep Practising

Students who asked this also explored

Continue with nearby questions to strengthen the same chapter concept while you still have the context fresh in mind.

Q1.

What does SQL stand for?

Q2.

Which of the following is a feature of SQL?

Q3.

What type of database management system is MySQL?

Q4.

What is a primary function of SQL?