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

|

951 Discussions

|

  • camealpure
     + 0 comments

    WITH RECURSIVE seq(n) AS ( SELECT 1 UNION ALL SELECT n+1 from seq WHERE n<20 ) SELECT REPEAT ('*',n) AS PATTERN FROM seq;

    why it is a wrong answer?

  • ardaozge00
     + 0 comments

    Oracle version:

    SELECT RPAD('* ', LEVEL * 2, '* ') FROM DUAL CONNECT BY LEVEL <=20 ;

  • kirill_d1
     + 0 comments
    DELIMITER ##
CREATE PROCEDURE p(IN im INT)
BEGIN
    DECLARE ic INT DEFAULT 1;
    WHILE ic <= im DO
        SELECT REPEAT('* ', ic);
        SET ic = ic + 1;
    END WHILE;
END##

DELIMITER ;

-- run procedure for 20:
CALL p(20);

  • vanshrathi361
     + 0 comments

    my sql server 

    SET @i := 0;

SELECT REPEAT('* ', @i := @i + 1)
FROM information_schema.tables
WHERE @i < 20;

  • swethascybsec
     + 0 comments

    MS SQL Server

    DECLARE @i INT = 1;
DECLARE @max INT = 20;

WHILE @i<=@max
BEGIN
   PRINT REPLICATE ('* ', @i)
   SET @i= @i+1
END