Draw The Triangle 2 HackerRank SQL Solution

Problem:-

P(R) represents a pattern drawn by Julia in R rows. The following pattern represents P(5):

* 
* * 
* * * 
* * * * 
* * * * *

Write a query to print the pattern P(20).

Solution:-

set @row := 0;

select repeat('* ', @row := @row + 1) from information_schema.tables where @row < 20