Multiple ChoiceHard 30s
Window functions
Choose the best answer for: window functions
Options
- 1GROUP BY collapses rows while window functions keep them
- 2ROW_NUMBER, RANK, LAG/LEAD operate on row sets
- 3Window functions can only run inside a subquery clause
- 4Window functions replace the need for any aggregation
Think you can answer under pressure?
Get matched and answer live questions in 3-minute 1v1 battles. Elo ranking, badge tiers and bragging rights on the line.