🎴 Flashcard Mode
Databases and SQL Fundamentals
Card1 / 20
Mastered0
Review0
QuestionClick to flip
In a SELECT statement that includes a WHERE clause, where is the GROUP BY clause placed in the SELECT statement?
AnswerClick to flip back
A
After the WHERE clause
💡 Explanation:
In a standard SQL SELECT statement, the clauses must follow a specific syntactic order: SELECT, FROM, WHERE, GROUP BY, HAVING, and ORDER BY. Therefore, the GROUP BY clause is placed immediately after the WHERE clause.