Aggregate

AVG

MySQL

Menghitung nilai rata-rata dari kolom numerik. Mengabaikan nilai NULL dan dapat menggunakan DISTINCT untuk menghitung rata-rata dari nilai unik saja.

Tipe hasil: DOUBLEDiperbarui: 7 Jan 2026

Syntax

SQL

AVG([DISTINCT] expr)

exprnumericwajib

Ekspresi numerik yang akan dihitung rata-ratanya

SQL

1 SELECT AVG(salary) AS avg_salary FROM employees;

Menghitung rata-rata gaji semua karyawan.

Hasil

avg_salary: 75000.00

SQL

1 SELECT AVG(rating) AS avg_rating
2 FROM reviews
3 WHERE product_id = 101;

Menghitung rata-rata rating untuk produk tertentu.

Hasil

avg_rating: 4.5

SQL

1 SELECT AVG(DISTINCT score) AS avg_unique_score
2 FROM test_results;

Menghitung rata-rata dari nilai skor yang unik saja.

Hasil

avg_unique_score: 82.5

SQL

1 SELECT department, AVG(salary) AS dept_avg_salary
2 FROM employees
3 GROUP BY department;

Menghitung rata-rata gaji per departemen.

Hasil

Sales: 65000, Engineering: 85000

1	SELECT AVG(rating) AS avg_rating
2	FROM reviews
3	WHERE product_id = 101;

1	SELECT AVG(DISTINCT score) AS avg_unique_score
2	FROM test_results;

1	SELECT department, AVG(salary) AS dept_avg_salary
2	FROM employees
3	GROUP BY department;