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

|

906 Discussions

|

  • kuldeepsapariya1
     + 0 comments

    MYSQL

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

  • qobiljonkhayrul1
     + 0 comments

    DECLARE @counter INT = 1;

    WHILE @counter <=20

    BEGIN

    PRINT REPLICATE('* ', @counter);

    SET @counter = @counter + 1

    END

  • aavcii030
     + 0 comments
    SELECT
    REPEAT('* ', @row := @row + 1) AS pattern
FROM
    (SELECT @row := 0) AS init,
    INFORMATION_SCHEMA.COLUMNS
LIMIT 20;

  • mudavathdevipra1
     + 0 comments
    WITH RECURSIVE nums AS (
    SELECT 1 AS n
    UNION ALL
    SELECT n + 1 FROM nums WHERE n < 20
)
SELECT REPEAT('* ', n)
FROM nums;

  • schouhan1819
     + 0 comments

    WITH RECURSIVE pattern AS ( SELECT 1 AS row_num UNION ALL SELECT row_num + 1 FROM pattern WHERE row_num < 20 ) SELECT REPEAT('* ', row_num) AS stars FROM pattern;