Annalect Reporting Analyst Interview Questions and Answers

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

• Window functions are used to perform calculations on a set of rows related to the current row

• They allow you to perform calculations without grouping the data

• Common window functions include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE()

• Tableau version should be specified based on the interviewer's requirement