Learn about SQL Job Interviews in this comprehensive SQL & Databases development tutorial. The classic question.
UNLOCK NODES BY LEARNING NEW TAGS.
A guaranteed question in any Backend interview is: 'What is the difference between WHERE and HAVING?'. The perfect answer is: 'WHERE filters rows before they are grouped. HAVING filters the groups after the aggregate functions have calculated the math.'
Pascual Vila
Frontend Instructor // Code Syllabus
Filter for aggregate results.
// HAVING contextFROM > WHERE > GROUP > HAVING
// Execution Order context