Math

SIGN

MySQL

Mengembalikan tanda dari angka: -1 untuk negatif, 0 untuk nol, 1 untuk positif.

Tipe hasil: INTEGERDiperbarui: 7 Jan 2026

Syntax

SQL

SIGN(x)

Parameter

xnumericwajib

Angka yang akan dicek tandanya

Contoh Penggunaan

Tanda Angka

SQL

1 SELECT SIGN(-10) AS neg, SIGN(0) AS zero, SIGN(10) AS pos;

Menentukan tanda dari angka.

Hasil

neg: -1, zero: 0, pos: 1

Kategorisasi Perubahan

SQL

1 SELECT product, current - previous AS change,
2   CASE SIGN(current - previous)
3     WHEN 1 THEN 'Increase'
4     WHEN -1 THEN 'Decrease'
5     ELSE 'No Change'
6   END AS trend
7 FROM inventory;

Mengkategorikan perubahan stok.

Hasil

(inventory changes categorized)

Profit/Loss

SQL

1 SELECT account,
2   CASE SIGN(balance)
3     WHEN 1 THEN 'Profit'
4     WHEN -1 THEN 'Loss'
5     ELSE 'Break Even'
6   END AS status
7 FROM accounts;

Status profit/loss berdasarkan balance.

Hasil

(profit/loss status)

Fungsi Terkait

ABSMODPOWERSQRT

Kembali ke MySQL Functions

1	SELECT product, current - previous AS change,
2	CASE SIGN(current - previous)
3	WHEN 1 THEN 'Increase'
4	WHEN -1 THEN 'Decrease'
5	ELSE 'No Change'
6	END AS trend
7	FROM inventory;

1	SELECT account,
2	CASE SIGN(balance)
3	WHEN 1 THEN 'Profit'
4	WHEN -1 THEN 'Loss'
5	ELSE 'Break Even'
6	END AS status
7	FROM accounts;