String

REVERSE

PostgreSQL

Membalik urutan karakter dalam string. Berguna untuk cek palindrome atau manipulasi string tertentu.

Tipe hasil: text

Syntax

SQL

REVERSE(string)

stringtextwajib

String yang akan dibalik

SQL

1 SELECT REVERSE(Hello);

Membalik string.

Hasil

reverse
olleH

SQL

1 SELECT 
2   word,
3   CASE 
4     WHEN LOWER(word) = LOWER(REVERSE(word)) THEN Palindrome
5     ELSE Not Palindrome
6   END AS result
7 FROM words;

Mengecek apakah kata adalah palindrome.

Hasil

SQL

1 SELECT 
2   LEFT(REVERSE(filename), POSITION(. IN REVERSE(filename)) - 1) AS extension_reversed
3 FROM files;

Teknik untuk mengambil ekstensi file dengan panjang variabel.

REVERSE

MySQL

REVERSE

Snowflake

REVERSE

BigQuery

REVERSE

DuckDB

1	SELECT
2	word,
3	CASE
4	WHEN LOWER(word) = LOWER(REVERSE(word)) THEN Palindrome
5	ELSE Not Palindrome
6	END AS result
7	FROM words;

1	SELECT
2	LEFT(REVERSE(filename), POSITION(. IN REVERSE(filename)) - 1) AS extension_reversed
3	FROM files;