Sort by

recency

|

945 Discussions

|

  • + 0 comments
    WITH RECURSIVE numbers AS (
      SELECT 1 AS i
      UNION ALL
      SELECT i + 1 FROM numbers WHERE i < 20
    )
    SELECT REPEAT(' *', i) AS stars
    FROM numbers;
    
  • + 0 comments

    For MySQL

    DELIMITER $$
    
    CREATE PROCEDURE pattern_print()
    BEGIN
        DECLARE i INT DEFAULT 1;
    
        WHILE i<=20 DO
            SELECT IF(i = 1, "*", REPEAT("* ", i));
            SET i = i + 1;
        END WHILE;
    END $$
    
    DELIMITER ;
    
    CALL pattern_print();
    
  • + 0 comments

    declare @a as int=1 while @a <= 20 begin print replicate ('*',@a) set @a=@a+1 end

    **2nd Way ** WITH Numbers AS ( SELECT 1 AS n UNION ALL SELECT n + 1 FROM Numbers WHERE n < 20 ) SELECT REPLICATE('* ', n) AS pattern FROM Numbers OPTION (MAXRECURSION 20);

  • + 0 comments

    The simplest way to solve this problem is this;

    WITH RECURSIVE numbers(n) AS( SELECT 1

        UNION ALL
    
        SELECT n + 1 FROM numbers WHERE n < 20
    

    )

    SELECT REPEAT('* ', n) FROM numbers;

  • + 0 comments
    DECLARE @I INT = 1
    WHILE @I<=20
    BEGIN
        SELECT REPLICATE("* ", @I)
        SET @I=@I+1
    END