What are the standard clauses in an analytics query?
A.
It includes a PARTITION clause, with required over_clause, order_clause, and frame_clause.
B.
It includes an OVER clause, with required partition_clause, order_clause, and frame_clause
C.
It includes an OVER clause, with optional partition_clause, order_clause, and frame_clause.
D.
It includes a PARTITION clause, with optional over_clause, order_clause, and frame clause.
Answer is C according to documentation.
http://my.vertica.com/docs/7.1.x/HTML/index.htm#Authoring/SQLReferenceManual/Functions/Analytic/AnalyticFunctions.htm
0
0