SQL Analytic Functions Quiz

Welcome to your SQL Analytic Functions Quiz

Which of the below statements is FALSE?

Analytic function returns a result for each row of the group

Aggregate function returns a single result for each group of rows

Analytic functions display only those columns which are in GROUP BY clause

Aggregate functions display only those columns which are in GROUP BY clause

A SQL query with Analytic Function should always use a GROUP BY clause at the end of the statement

TRUE

FALSE

Which of the below statements about Analytic Functions is FALSE?

Partition Clause defines the group of rows upon which the aggregation needs to be done

The Windowing Clause can be used without order by clause

The PARTITION clause is not a mandatory clause in every Analytic Function

The ORDER BY clause is not a mandatory clause in every Analytic Function

Which of the below statements about LEAD and LAG functions is FALSE?

LEAD Function fetch the row details of the next record

LEAD Function is exact opposite of the LAG Function

LAG Function fetch the row details of the previous record

LAG Function fetch the row details of the next record

Which of the below statements about RANK and DENSE_RANK functions is FALSE?

RANK function will skip the next rank when multiple records gets the same rank

ORDER BY Clause is not mandatory when using RANK or DENSE_RANK functions

DENSE_RANK will not skip the next rank when multiple records gets the same rank

PARTITION Clause is not mandatory when using RANK or DENSE_RANK functions