Eaton Power BI Developer Interview Questions and Answers

Analytical functions in SQL are used to perform calculations across a set of rows related to the current row.

• Analytical functions operate on a group of rows and return a single result for each row.

• They can be used to calculate running totals, moving averages, rank, percentiles, etc.

• Examples of analytical functions include ROW_NUMBER(), RANK(), SUM(), AVG(), etc.