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

|

940 Discussions

|

  • lokendrakaran004
     + 0 comments

    FOR MYSQL

    WITH RECURSIVE CTE(N) AS( SELECT 1 AS N UNION ALL SELECT N+1 FROM CTE WHERE N<20) SELECT REPEAT (' * ',N) FROM CTE

  • me22btech11026
     + 0 comments

    WITH RECURSIVE numbers(n) AS( SELECT 1

     UNION ALL

 SELECT n+1 FROM numbers WHERE n < 20 
 )
 SELECT 
 TRIM(TRAILING ' ' FROM REPEAT('* ', n)) AS line
 FROM numbers;

  • j_ibarralemp
     + 0 comments

    Similar logic to the other triangle exercise (MS SQL Server)

    DECLARE @n AS INT = 1
WHILE @n <= 20
BEGIN
    PRINT REPLICATE('* ', @n)
    SET @n = @n + 1
END
;

  • imvinitanand
     + 0 comments

    SQL server:

    declare @counter int =1
declare @j varchar(100)='*'
declare @i varchar ='*'

while @counter<=20
begin
 print @j
 set @J=@J+' '+@i
 set @counter=@counter+1
end

  • rakshit126
     + 0 comments
    declare @r int;`
set @r= 0;
while (@r<=20)
begin
select REPLICATE('*'+char(9),@r);
set @r=@r+1
end;