What are valid sub-clauses to the OVER clause for a window function? (Choose two.)
What are valid sub-clauses to the OVER clause for a window function? (Choose two.)
For a window function, valid sub-clauses to the OVER clause are ORDER BY and PARTITION BY. ORDER BY is used to define the order in which the rows are processed by the window function, and PARTITION BY is used to divide the result set into partitions to which the window function is applied. Other options like GROUP BY, LIMIT, and UNION ALL are not specific to the OVER clause for window functions.
CD correct - syntax <function> ([ <arguments> ]) OVER ([ PARTITION BY <expr1> ] [ ORDER BY <expr2> ])
Similarly to standard SQL syntax - C and D
CD correct