String

RIGHT

Snowflake

Mengambil sejumlah karakter dari sisi kanan (akhir) string.

Tipe hasil: VARCHARDiperbarui: 6 Jan 2026

Syntax

SQL

RIGHT(string, length)

stringVARCHARwajib

String sumber

lengthINTEGERwajib

Jumlah karakter yang diambil dari kanan

SQL

1 SELECT RIGHT('Snowflake', 5) as result;

Mengambil 5 karakter terakhir dari string.

Hasil

flake

SQL

1 SELECT
2   filename,
3   RIGHT(filename, 3) as extension
4 FROM files
5 WHERE RIGHT(filename, 3) IN ('csv', 'txt', 'pdf');

Mengambil 3 karakter terakhir sebagai ekstensi file.

Hasil

FILENAME	EXTENSION
data.csv	csv
report.pdf	pdf

SQL

1 SELECT
2   card_number,
3   '****-****-****-' || RIGHT(card_number, 4) as masked_card
4 FROM payments;

Menampilkan hanya 4 digit terakhir dari nomor kartu kredit.

Hasil

CARD_NUMBER	MASKED_CARD
1234567890123456	**--**-3456

1	SELECT
2	filename,
3	RIGHT(filename, 3) as extension
4	FROM files
5	WHERE RIGHT(filename, 3) IN ('csv', 'txt', 'pdf');

1	SELECT
2	card_number,
3	'**--**-' \|\| RIGHT(card_number, 4) as masked_card
4	FROM payments;