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

|

962 Discussions

|

  • girishbablani546
     + 0 comments

    In SQL Server

    SET NOCOUNT ON;

    Declare @i int = 1; Declare @Star varchar(max)= '';

    While @i < 21 BEGIN SET @Star = REPLICATE('* ',@i) PRINT LEFT(@Star,LEN(@Star)) SET @i = @i + 1 END
    go

  • ashishkhulbey
     + 0 comments
    delimiter //

create procedure patt()

BEGIN
declare counter integer default 1;
    while counter <= 20 DO
    select repeat("* ", counter);
    set counter = counter + 1;
    end while;
END

//

delimiter ;

call patt();

  • jpconcerman
     + 0 comments

    WITH stars (lvl, line) AS ( SELECT 1, '*' FROM dual UNION ALL SELECT lvl + 1, line || ' *' FROM stars WHERE lvl < 20 ) SELECT line FROM stars;

  • jpconcerman
     + 0 comments

    SELECT ( SELECT LISTAGG('*', ' ') WITHIN GROUP (ORDER BY LEVEL) FROM dual CONNECT BY LEVEL <= outer_query.numt ) AS star_line FROM ( SELECT LEVEL AS numt FROM dual CONNECT BY LEVEL <= 5 ) outer_query;

  • akshata_loya27
     + 0 comments

    WITH RECURSIVE Pattern AS( Select 1 as Level UNION ALL Select level + 1 From Pattern where level < 20 ) Select REPEAT('* ',level) as pattern from Pattern;