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

|

967 Discussions

|

  • mrityunjaips1924
     + 0 comments

    with p(n) as ( select 1 as n union all select n+1 from p where n<20 ) select replicate(' *',n) from p;

  • amitmishra64383
     + 0 comments

    WITH RECURSIVE traingle(n) AS ( SELECT 1 AS n

    UNION ALL 

SELECT n+1 FROM traingle
WHERE n < 20

    )

    SELECT REPEAT("* ",n) FROM traingle ;

  • amitmishra64383
     + 0 comments

    WITH RECURSIVE traingle(n) AS ( SELECT 1 AS n

    UNION ALL 

SELECT n+1 FROM traingle
WHERE n < 20

    )

    SELECT REPEAT("* ",n) FROM traingle ;

  • meenareddy2629
     + 0 comments

    set @row := 0; select repeat( "* ",@row:=@row+1) from information_schema.tables limit 20

  • asrithakovvuri17
     + 0 comments
    SET SESSION group_concat_max_len = 100000;

WITH RECURSIVE seq AS (
  SELECT 1 AS r
  UNION ALL
  SELECT r + 1
  FROM seq
  WHERE r < 20
),
line AS (
  SELECT
    s.r AS row_num,
    TRIM(BOTH ' ' FROM
      GROUP_CONCAT('*' ORDER BY t.r SEPARATOR ' ')
    ) AS pattern
  FROM seq s
  JOIN seq t ON t.r <= s.r
  GROUP BY s.r
)
SELECT CONCAT(pattern) AS line
FROM line
ORDER BY row_num;