String

RIGHT

DuckDB

Mengambil sejumlah karakter dari sisi kanan (akhir) string.

Tipe hasil: VARCHARDiperbarui: 6 Jan 2026

Syntax

SQL

RIGHT(string, count)

stringVARCHARwajib

String sumber

countINTEGERwajib

Jumlah karakter yang diambil

SQL

1 SELECT RIGHT('invoice_2024_001', 3);

Mengambil 3 karakter terakhir.

Hasil

001

SQL

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

Mengambil ekstensi file.

SQL

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

Menampilkan 4 digit terakhir kartu kredit.

Hasil

****-****-****-1234

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