sql-笛卡尔积的简单应用

– 遍历字符串，每行按顺序输出一个字符
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);

台风早日走，等雨停，等天晴。