13-COUNT, AVG, SUM in SQL

La funcion COUNT devuelve el numero de filas que coincide con la condicion WHERE

Sintaxis COUNT

SELECT COUNT(column_name)
FROM table_name
WHERE condition; 
   

---

...

Sintaxis AVG

SELECT AVG(column_name)
FROM table_name
WHERE condition; 
   

---

Sintaxis SUM

SELECT SUM(column_name)
FROM table_name
WHERE condition; 
   

---

Ejemplo de COUNT

SELECT COUNT(ProductID)
FROM Products;
   

---

Ejemplo de AVG

SELECT AVG(Price)
FROM Products;
   

---

Ejemplo de SUM

SELECT SUM(Quantity)
FROM OrderDetails; 
   

---

Ir al indice