Repeat1 HackerRank SQL - Draw The Triangle 1, 2 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). Problem 패턴 P(20)을 출력하는 쿼리을 작성하라. (패턴 P는 행의 갯수만큼 '*'를 반복해서 출력함) Answer1 WITH RECURSIVE my_cte AS ( SELECT 1 AS n UNION ALL SELECT 1+n FROM my_cte WHERE n 2023. 1. 25. 이전 1 다음