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

|

961 Discussions

|

  • 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;

  • eddy_rene_c
     + 0 comments

    in SQL server:

    WITH numbers AS (
    SELECT CAST('* ' AS VARCHAR(50)) as t, 1 as n
    UNION ALL
    SELECT CAST(CONCAT(t, '* ') AS VARCHAR(50)) , n+1  FROM numbers WHERE n < 20
)
SELECT t FROM numbers;