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

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