Pregunta de entrevista de freelance

SQL aggregation functions perform calculations on a set of values in a column?

Respuesta de la entrevista

Anónimo

22 abr 2024

COUNT: Returns the number of rows in a specified column or table. SUM: Returns the sum of all values in a specified column. AVG: Returns the average value of a specified column. MIN: Returns the smallest value in a specified column. MAX: Returns the largest value in a specified column. GROUP_CONCAT: Concatenates non-NULL values from a specified column into a single string, separated by a specified separator. COUNT(DISTINCT): Returns the number of unique values in a specified column. SUM(DISTINCT): Returns the sum of unique values in a specified column. AVG(DISTINCT): Returns the average of unique values in a specified column. VARIANCE: Returns the variance of the values in a specified column. STDDEV: Returns the standard deviation of the values in a specified column.