С
Size: a a a
2021 October 01
YN
Выбери сверху восьмую версию
YN
WITH TestCTE AS
( SELECT 1 AS Id
UNION
SELECT 2)
SELECT * FROM TestCTE
( SELECT 1 AS Id
UNION
SELECT 2)
SELECT * FROM TestCTE
YN
Селект после скобки должен быть
YN
WITH RECURSIVE cte AS
(
SELECT 1 AS n, CAST('abc' AS CHAR(20)) AS str
UNION ALL
SELECT n + 1, CONCAT(str, str) FROM cte WHERE n < 3
)
SELECT * FROM cte;
(
SELECT 1 AS n, CAST('abc' AS CHAR(20)) AS str
UNION ALL
SELECT n + 1, CONCAT(str, str) FROM cte WHERE n < 3
)
SELECT * FROM cte;
YN
Ща буду в манула лицом макать