Pregunta de entrevista de LTM Limited

SQL windows aggregate functions and stored procedures

Respuesta de la entrevista

Anónimo

19 ago 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.