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

|

1306 Discussions

|

  • rjlharrylees
     + 0 comments

    *Counting down from 20: * WITH RECURSIVE counter AS ( SELECT 20 as n UNION ALL SELECT n - 1 FROM counter WHERE n > 1 ) SELECT REPEAT('* ', n) FROM counter;

  • madhanpayasam5
     + 0 comments

    MY SQL SET @row := 6;

    SELECT REPEAT('* ', @row := @row - 1) FROM information_schema.tables LIMIT 5;

  • sairuthwik2002
     + 0 comments

    My Sql:

    WITH RECURSIVE triangle(NUMBER) as (SELECT 1 AS NUMBER

    UNION ALL

    SELECT NUMBER+1 FROM triangle WHERE NUMBER < 20 )

    SELECT REPEAT('* ',NUMBER) FROM triangle ORDER BY NUMBER DESC;

  • hari33113
     + 0 comments

    with RECURSIVE cte as( select 20 as nm union all select nm-1 from cte where nm>1 ) SELECT repeat( '* ',nm) from cte

  • thanushmn29
     + 2 comments

    select "* * * * * * * * * * * * * * * * * * * *"; select " * * * * * * * * * * * * * * * * * * *"; select " * * * * * * * * * * * * * * * * * *"; select " * * * * * * * * * * * * * * * * *"; select " * * * * * * * * * * * * * * * *"; select " * * * * * * * * * * * * * * *"; select " * * * * * * * * * * * * * *"; select " * * * * * * * * * * * * *"; select " * * * * * * * * * * * *"; select " * * * * * * * * * * *"; select " * * * * * * * * * *"; select " * * * * * * * * *"; select " * * * * * * * *"; select " * * * * * * *"; select " * * * * * *"; select " * * * * *"; select " * * * *"; select " * * *"; select " * "; select "";