Discussion on Draw The Triangle 1 Challenge

Sort by

recency

|

1249 Discussions

|

2 days ago+ 0 comments

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

2 weeks ago+ 0 comments

For Mysql using the RECURSIVE statement:

WITH RECURSIVE cnt (n) AS ( SELECT 20 UNION ALL SELECT n - 1 FROM cnt WHERE n > 1 ) SELECT REPEAT("* ", n) FROM cnt;

2 weeks ago+ 0 comments

MS SQL Server

DECLARE @i int = 0

WHILE @i <= 20
BEGIN
    SELECT REPLICATE("* ", 20 - @i)
    SET @i = @i + 1
END

2 weeks ago+ 0 comments

WITH RECURSIVE Patterns(n) as( Select cast('' as char(255)) UNION ALL Select concat(n, '') from Patterns where length(n) < 20
) select * from Patterns ORDER BY length(n) DESC; Please Whats wrong with my code. It prints out the *.

2 weeks ago+ 0 comments

MS SQL - This code works; DECLARE @n INT = 20; DECLARE @i INT = 20; DECLARE @p VARCHAR(100) = '';

WHILE @i <= @n AND @i>0 BEGIN DECLARE @j INT = 1; SET @p = '' WHILE @j<=@i BEGIN SET @p = @p + '* '; SET @j = @j + 1; END PRINT @p; SET @i = @i - 1; END

Sort by

|

1249 Discussions

|

Cookie support is required to access HackerRank

Please signup or login in order to view this challenge