WITH RECURSIVE Pattern AS ( SELECT 20 AS num UNION ALL SELECT num - 1 FROM Pattern WHERE num > 1 ) SELECT REPEAT('* ', num) FROM Pattern;

Use MySql :-

WITH RECURSIVE Pattern AS ( SELECT 20 AS row_num UNION ALL SELECT row_num - 1 FROM Pattern WHERE row_num > 1 ) SELECT REPEAT('* ', row_num) AS pattern_row FROM Pattern;

You can try this one... (-:)

Use of sqlserver 2022 features:

SELECT REPLICATE('* ', value) FROM GENERATE_SERIES(20, 1)

DELIMITER $

CREATE PROCEDURE triangulo()

BEGIN

DECLARE p INT DEFAULT 20;

DECLARE ii INT DEFAULT 1;

DECLARE txt VARCHAR(50) DEFAULT '';

WHILE 1 <= p DO
    SET ii = 1;
    SET txt = '';
        WHILE ii <= p DO
            SET txt = CONCAT(txt, '* ');
            SET ii = ii + 1;
        END WHILE;
        SELECT txt;
    SET p = p - 1;
END WHILE;

END$

CALL triangulo() `

with recursive num_ct as (select 20 as num union all select num-1 from num_ct where num>1) select trim(repeat('*',num)) as apt from num_ct order by num desc;

why is this not working? it gives the correct output tho..