Sollicitatievraag bij LTM Limited
SQL windows aggregate functions and stored procedures
Antwoord op sollicitatievraag
Anoniem
19 aug 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.