• + 0 comments
    WITH RECURSIVE pattern(n) AS (
        SELECT 20   -- start from 20
        UNION ALL
        SELECT n - 1 FROM pattern WHERE n > 1   -- decrease by one for each row
    )
    SELECT 
        REPEAT('* ', n)    -- don't forget space
    FROM 
        pattern;