> > >

SQL MCQs

What is the difference between WHERE and HAVING clauses?

HAVING cannot use aggregate function to filter records whereas WHERE can use aggregate function to filter records

None of these

HAVING filter records before the GROUP BY while WHERE filter records after the GROUP BY clause

HAVING filter records after the GROUP BY while WHERE filter records before the GROUP BY clause

Answer

Correct Answer: HAVING filter records after the GROUP BY while WHERE filter records before the GROUP BY clause

Explanation:

Note: This Question is unanswered, help us to find answer for this one

SQL Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it