Dell-EMC
E20-007 · Question #143
What is a property of window functions in SQL commands?
The correct answer is D. They can be used to calculate moving averages over various intervals. See the full explanation below for the reasoning.
Question
What is a property of window functions in SQL commands?
Options
- AThey don't require ordering of data within a window.
- BThey group rows into a single output row.
- CThey can be used between the keywords FROM and WHERE in a SELECT command.
- DThey can be used to calculate moving averages over various intervals.
How the community answered
(30 responses)- A3% (1)
- B10% (3)
- C3% (1)
- D83% (25)
Community Discussion
No community discussion yet for this question.