为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:
【操作系统】:
【CPU】:
【问题描述】*:CREATE VIEW “SYSDBA”.“V_AZ06_A” (“AAE101”,“AAZ007”,“AAZ006”)
AS
select “A”.“AAE101” AS “AAE101”,sum((case when (“A”.“AAE414” = ‘1’) then “A”.“AAE405” when (“A”.“AAE414” = ‘0’) then 0 end)) AS “AAZ007”,
sum((case when (“A”.“AAE414” = ‘1’) then 1 when (“A”.“AAE414” = ‘0’) then 0 end)) AS “AAZ006” from “AE04” “A” where ((“A”.“AAE100” = ‘1’) and
(“A”.“AAE416” >= cast((cast(now() as date) - interval 1 day) as date))) group by “A”.“AAE101”
执行失败(语句1)
-2007: 第 5 行, 第 80 列[1]附近出现错误:
语法分析出错
有没有大神知道这是什么问题
cast((cast(now() as date) - interval 1 day) as date)) 这一段改成 now()-1
(cast(now() as date) - interval ‘1’ day