Re: MS SQL Server to MySQL for WITH

[Ra Nala]

select ab.col1,ab.col2 from
(
SELECT 1 AS col1, 2 AS col2
UNION ALL
SELECT 3, 4
)ab

Is above mysql syntax is correct approach sir


below MS SQL SERVER syntax

WITH cte AS
(
SELECT 1 AS col1, 2 AS col2
UNION ALL
SELECT 3, 4
)
SELECT col1, col2 FROM cte;