Math

ABS

MySQL

Mengembalikan nilai absolut (positif) dari angka. Menghilangkan tanda negatif.

Tipe hasil: Same as inputDiperbarui: 7 Jan 2026

Syntax

SQL

ABS(x)

Parameter

xnumericwajib

Angka yang akan diambil nilai absolutnya

Contoh Penggunaan

Nilai Absolut

SQL

1 SELECT ABS(-15.5) AS absolute;

Menghilangkan tanda negatif.

Hasil

absolute: 15.5

Jarak dari Target

SQL

1 SELECT product, sales, target,
2   ABS(sales - target) AS variance
3 FROM performance;

Menghitung selisih absolut dari target.

Hasil

(absolute variance from target)

Sorting by Distance

SQL

1 SELECT name, latitude, longitude,
2   ABS(latitude - 40.7128) + ABS(longitude - (-74.0060)) AS distance
3 FROM locations
4 ORDER BY distance
5 LIMIT 5;

Manhattan distance dari New York.

Hasil

(locations closest to NYC)

Fungsi Terkait

SIGNMODPOWERSQRT

Kembali ke MySQL Functions

1	SELECT product, sales, target,
2	ABS(sales - target) AS variance
3	FROM performance;

1	SELECT name, latitude, longitude,
2	ABS(latitude - 40.7128) + ABS(longitude - (-74.0060)) AS distance
3	FROM locations
4	ORDER BY distance
5	LIMIT 5;