delimiter // create procedure patt() BEGIN declare counter int default 20; while (counter)>0 DO select repeat('* ', counter); set counter = counter -1; end while; end //

delimiter ;

call patt();

For MySQL Platform

DELIMITER ##

CREATE PROCEDURE pattern_print()
BEGIN
    DECLARE i INT DEFAULT 20;
    
    WHILE i>0 DO
        SELECT IF(i=1, "*", REPEAT("* ", i));
        SET i = i - 1;
    END WHILE;
END ##

DELIMITER ;

CALL pattern_print();

GUYS EASIEST ONE DECLARE @j INT = 20; WHILE (@j > 0) BEGIN PRINT REPLICATE('* ', @j) SET @j = @j - 1; -- decrement j END

MySQL:

WITH RECURSIVE numbers AS ( SELECT 1 AS level UNION ALL SELECT level + 1 FROM numbers WHERE level < 20 ) SELECT RPAD('* ', 2 * (21 - level), '* ') AS pattern FROM numbers ORDER BY level;

In SQL Server

DECLARE @i AS INT = 20  
WHILE @i <= 20 AND @i >= 1  
BEGIN  
	``PRINT REPLICATE('* ', @i)  
	SET @i = @i   - 1  
END