昨天我问了一个关于复杂查询的问题,我得到了一个例子。我真的很想让它工作,但它有一个语法错误,我找不出来。请记住,这周早些时候我刚刚被介绍到CTE,所以希望这是一个简单的。 with cte as (select dateadd(hour, 1, cast(cast(getdate() -1 as date) as datetime)) as midnnight), select 0 as hour, midnight as timestart, dateadd(hour, 1, timestart) as