This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
What must be specified with the RANK function?
PARTITION BY
CURRENT ROW
ORDER BY
In what order should the ROW, OVER, and PARTITION BY keywords occur in a query?
PARTITION BY, OVER, ROW
ROW, OVER, PARTITION BY
OVER PARTITION BY, ROW
What type of window function is PERCENT_RANK()?
Analytic function
Ranking function
Aggregation function
You must answer all questions before checking your work.
Was this page helpful?
Need help with this topic?
Want to try using Ask Learn to clarify or guide you through this topic?