String

REVERSE

DuckDB

Membalik urutan karakter dalam string. Karakter pertama menjadi terakhir dan sebaliknya.

Tipe hasil: VARCHARDiperbarui: 6 Jan 2026

Syntax

SQL

REVERSE(string)

Parameter

stringVARCHARwajib

String yang akan dibalik urutannya

Contoh Penggunaan

Membalik String Sederhana

SQL

1 SELECT
2   original,
3   REVERSE(original) as reversed
4 FROM (
5   SELECT 'Hello' as original UNION ALL
6   SELECT 'DuckDB' UNION ALL
7   SELECT '12345'
8 );

Membalik urutan karakter dalam string.

Hasil

original	reversed
Hello	olleH
DuckDB	BDkcuD
12345	54321

Cek Palindrome

SQL

1 SELECT
2   word,
3   CASE
4     WHEN LOWER(word) = LOWER(REVERSE(word)) THEN 'Palindrome'
5     ELSE 'Not Palindrome'
6   END as is_palindrome
7 FROM (
8   SELECT 'Katak' as word UNION ALL
9   SELECT 'Kasur' UNION ALL
10   SELECT 'Malam'
11 );

Mengecek apakah kata adalah palindrome (dibaca sama dari depan dan belakang).

Hasil

word	is_palindrome
Katak	Palindrome
Kasur	Not Palindrome
Malam	Palindrome

Extract Domain dari Email (Reverse Approach)

SQL

1 SELECT
2   email,
3   REVERSE(SPLIT_PART(REVERSE(email), '@', 1)) as domain
4 FROM users;

Teknik alternatif untuk mengambil bagian terakhir setelah @.

Hasil

email	domain
budi@gmail.com	gmail.com
ani@company.co.id	company.co.id

Fungsi Terkait

REPEATASCIICHR

Kembali ke DuckDB Functions

1	SELECT
2	original,
3	REVERSE(original) as reversed
4	FROM (
5	SELECT 'Hello' as original UNION ALL
6	SELECT 'DuckDB' UNION ALL
7	SELECT '12345'
8	);

1	SELECT
2	word,
3	CASE
4	WHEN LOWER(word) = LOWER(REVERSE(word)) THEN 'Palindrome'
5	ELSE 'Not Palindrome'
6	END as is_palindrome
7	FROM (
8	SELECT 'Katak' as word UNION ALL
9	SELECT 'Kasur' UNION ALL
10	SELECT 'Malam'
11	);

1	SELECT
2	email,
3	REVERSE(SPLIT_PART(REVERSE(email), '@', 1)) as domain
4	FROM users;