SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
WITH ReverseCTE (str, reversed) AS ( SELECT 'your_string', '' -- Initial values UNION ALL SELECT SUBSTRING(str, 1, LEN(str) - 1), reversed + SUBSTRING(str, LEN(str), 1) FROM ReverseCTE WHERE LEN(str) > 1 ) SELECT reversed FROM ReverseCTE WHERE LEN(str) = 0; -- Base case: empty string

Stuck with a problem? Got Error? Ask ChatGPT!

Copy Clear