Question

Which of the following is the correct syntax for a GROUP BY clause in SQLite?

a) GROUP BY columns ORDER BY columns

b) ORDER BY column GROUP BY columns

c) GROUP columns BY ORDER column

d) None of the above

Answer 1

Answer: a) GROUP BY columns ORDER BY column

Explanation: The correct syntax for a GROUP BY clause in SQLite is GROUP BY columns ORDER BY column.