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

|

925 Discussions

|

  • candiaruben2
     + 0 comments

    with recursive numbers as ( select 1 as n union all select n + 1 as n from numbers where n < 20 ) select repeat('* ', n) from numbers

  • PThie
     + 0 comments

    MS SQL Server

    DECLARE @i int = 0

WHILE @i <= 20
BEGIN
    SELECT REPLICATE("* ", @i)
    SET @i = @i + 1
END

  • emhhacker
     + 0 comments

    MySQL solution:

    SET @number = 0;
SELECT REPEAT('* ', @number := @number + 1)
FROM information_schema.tables
LIMIT 20;

  • k_m_sathishkumar
     + 0 comments

    WITH recursive SLNO AS ( SELECT 1 Id UNION ALL SELECT Id + 1 Id FROM SLNO where Id < 20 ) ,SLNO1 AS ( SELECT 1 Id UNION ALL SELECT Id + 1 Id FROM SLNO where Id < 20 ) SELECT (SELECT group_concat('*' SEPARATOR ' ') FROM SLNO1 WHERE SLNO1.Id <= SLNO.Id) ID FROM SLNO ;

  • maheshr3002
     + 0 comments

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