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

|

1272 Discussions

|

  • vanshrathi361
     + 0 comments

    my sql query

    SET @i := 21;

SELECT REPEAT('* ', @i := @i - 1)
FROM information_schema.tables
WHERE @i > 1;

  • swethascybsec
     + 0 comments

    MS SQL Server

    DECLARE @i INT = 20;
DECLARE @min INT =1;

WHILE @i>=@min
BEGIN
    PRINT REPLICATE('* ', @i)
    SET @i= @i-1
END

  • armaanfirozbelim
     + 0 comments

    WITH RECURSIVE NumberSeries AS ( SELECT 1 AS row_num UNION SELECT row_num + 1 FROM NumberSeries WHERE row_num < 20 ) SELECT REPEAT('* ', 20 - row_num + 1) AS pattern_line FROM NumberSeries

  • swarnavagayen
     + 0 comments
    WITH RECURSIVE numbers AS (
    SELECT 20 AS n
    UNION ALL
    SELECT n - 1 FROM numbers WHERE n > 0 
)
SELECT REPEAT('* ', n) FROM numbers;

  • rom_adv
     + 0 comments
    -- For MySQL

-- Method 1: Query Based

WITH RECURSIVE numbers AS (
  SELECT 20 AS i
  UNION ALL
  SELECT i - 1 FROM numbers WHERE i > 1
)
SELECT REPEAT('*', i) AS stars
FROM numbers;

-- Method 2: Using  stored procedure

CREATE PROCEDURE p()
BEGIN
    DECLARE i INT DEFAULT 20;
    WHILE i >= 1 DO
        SELECT REPEAT('* ', i);
        SET i = i - 1;
    END WHILE;
END##

DELIMITER ;

-- To run the procedure:
CALL p();