LTM Limited Interview Question
SQL windows aggregate functions and stored procedures
Interview Answer
Anonymous
Aug 19, 2025
These functions calculate an aggregate value (like a sum, average, or count) over the window. SUM(): Calculates the sum of a set of values. AVG(): Calculates the average of a set of values. COUNT(): Counts the number of rows in the window. MIN(): Finds the minimum value in the window. MAX(): Finds the maximum value in the window.