在SQL Server中,CTE 的正确语法是什么?( )
select [column] from cte myCTE ([column]) as (select ...);
with select [column] from myCTE ([column]) as (select ...);
with myCTE ([column]) as (select ...) select [column] from myCTE;
using cte myCTE ([column]) as (select ...) select [column] from myCTE;