– 遍历字符串,每行按顺序输出一个字符
WITH
t5 AS ( SELECT 1 AS pos UNION ALL SELECT 2 AS pos UNION ALL SELECT 3 AS pos UNION ALL SELECT 4 AS pos UNION ALL SELECT 5 AS pos )
,emp AS ( SELECT ‘KING’ AS name )
SELECT *
FROM emp
,t5;
WITH
t5 AS ( SELECT 1 AS pos UNION ALL SELECT 2 AS pos UNION ALL SELECT 3 AS pos UNION ALL SELECT 4 AS pos UNION ALL SELECT 5 AS pos )
,emp AS ( SELECT ‘KING’ AS name )
SELECT substr(name, pos, 1) letter
FROM emp
,t5
WHERE t5.pos <= length(emp.name);
WITH
t5 AS ( SELECT 1 AS pos UNION ALL SELECT 2 AS pos UNION ALL SELECT 3 AS pos UNION ALL SELECT 4 AS pos UNION ALL SELECT 5 AS pos )
,emp AS ( SELECT ‘KING’ AS name )
SELECT name,pos
,substr(name, pos) char_name1
,substr(name, length(name)-pos+1) char_name1
FROM emp
,t5
WHERE t5.pos <= length(emp.name);
台风早日走,等雨停,等天晴。