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 1
  5. Discussions

Draw The Triangle 1

Sort by

recency

|

1221 Discussions

|

  • r_mohebb73
     + 0 comments

    Declare @i As int =20; Declare @tbl As Table (myStr varchar(max)) Declare @str As varchar(max) While(@i>0) Begin Set @str = REPLICATE('* ',@i); Insert into @tbl(myStr) values (@str) Set @i = @i-1 End select * from @tbl

  • anw_g01
     + 0 comments
    WITH RECURSIVE pattern(n) AS (
    SELECT 20   -- start from 20
    UNION ALL
    SELECT n - 1 FROM pattern WHERE n > 1   -- decrease by one for each row
)
SELECT 
    REPEAT('* ', n)    -- don't forget space
FROM 
    pattern;

  • pm3379
     + 0 comments

    select ('* * * * * * * * * * * * * * * * * * * '); select (' * * * * * * * * * * * * * * * * * '); select (' * * * * * * * * * * * * * * * * '); select (' * * * * * * * * * * * * * * * '); select (' * * * * * * * * * * * * * * '); select (' * * * * * * * * * * * * * '); select (' * * * * * * * * * * * * '); select (' * * * * * * * * * * * '); select (' * * * * * * * * * * '); select (' * * * * * * * * * '); select (' * * * * * * * * '); select (' * * * * * * * '); select (' * * * * * * '); select (' * * * * * '); select (' * * * * '); select (' * * * '); select (' * * '); select (' * '); select (' '); select ('');

  • prshahbaz74
     + 1 comment

    what's wrong with this SQL query output coming correct but use case failed. declare @countercheck int; set @countercheck=20; while(@countercheck>0) begin select REPLICATE('*',@countercheck) set @countercheck=@countercheck-1; end

  • kuldeepsapariya1
     + 0 comments

    MYSQL

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