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

|

929 Discussions

|

  • panditsonu7249
     + 0 comments

    SET SERVEROUTPUT ON;

    DECLARE v VARCHAR2(250); num NUMBER := 20; BEGIN FOR i IN 1..num LOOP v := v || '* '; DBMS_OUTPUT.PUT_LINE(v); END LOOP; END; /

  • harshitt159
     + 0 comments
    With recursive Stars AS
       (Select 
        1 as r
       union All
        select r+1 from stars
        where r<20)
Select repeat(' *',r) 
From stars

  • tusianisergio
     + 0 comments

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

  • rkishoreatr1207
     + 0 comments
    DECLARE @Row INT = 20

;WITH PatternCTE AS (
    SELECT 
        CAST('*' AS NVARCHAR(200)) AS Asterisk, 
        1 AS Num    
    UNION ALL
    SELECT 
        CAST(CONCAT(Asterisk, ' ', '*') AS NVARCHAR(200)) AS Asterisk, 
        Num + 1 AS Num 
    FROM PatternCTE 
    WHERE Num < @Row
)
SELECT Asterisk FROM PatternCTE;

  • 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