We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
  1. Prepare
  2. SQL
  3. Alternative Queries
  4. Draw The Triangle 2
  5. Discussions

Draw The Triangle 2

Sort by

recency

|

945 Discussions

|

  • rom_adv
     + 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;

  • SVVBathini
     + 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();

  • shukla12798
     + 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);

  • Neerav_Singhwal
     + 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;

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