Math

SIGN

BigQuery

Mengembalikan tanda dari angka: -1, 0, atau 1.

Tipe hasil: INT64 or FLOAT64Diperbarui: 7 Jan 2026

Syntax

SQL

SIGN(expression)

Parameter

expressionINT64/FLOAT64/NUMERICwajib

Nilai numerik

Contoh Penggunaan

Menentukan Tanda

SQL

1 SELECT
2   value,
3   SIGN(value) as sign
4 FROM UNNEST([-10, 0, 5, -0.5]) as value;

Mengekstrak tanda dari angka.

Hasil

value	sign
-10	-1
0	0
5	1
-0.5	-1

Trend Direction

SQL

1 SELECT
2   month,
3   revenue,
4   LAG(revenue) OVER (ORDER BY month) as prev_revenue,
5   CASE SIGN(revenue - LAG(revenue) OVER (ORDER BY month))
6     WHEN 1 THEN 'Up'
7     WHEN -1 THEN 'Down'
8     ELSE 'Flat'
9   END as trend
10 FROM `project.dataset.monthly_sales`;

Menentukan arah trend revenue.

Fungsi Terkait

ABSMODPOWERSQRTDIV

Kembali ke BigQuery Functions

1	SELECT
2	value,
3	SIGN(value) as sign
4	FROM UNNEST([-10, 0, 5, -0.5]) as value;

1	SELECT
2	month,
3	revenue,
4	LAG(revenue) OVER (ORDER BY month) as prev_revenue,
5	CASE SIGN(revenue - LAG(revenue) OVER (ORDER BY month))
6	WHEN 1 THEN 'Up'
7	WHEN -1 THEN 'Down'
8	ELSE 'Flat'
9	END as trend
10	FROM `project.dataset.monthly_sales`;