【求助】SQL语句在Rstudio中报错，求教！

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

下面这段SQL语句在Rstudio里执行的时候报了条件语句格式的问题，尝试更改更格式还是不行，求教各位，感谢！
SELECT
YEAR(PaymentDate) as year,
MONTH(PaymentDate) as month,
cast(sum(SalesTotalPrice*CurrencyToUSDRate) as DECIMAL(12,2)) as sale
FROM
HofanDW_DW_History.dbo.FactOrderDetail2_History
GROUP BY
MONTH(PaymentDate),YEAR(PaymentDate)
UNION
SELECT
YEAR(PaymentDate) as year,
MONTH(PaymentDate) as month,
cast(sum(SalesTotalPrice*CurrencyToUSDRate) as DECIMAL(12,2)) as sale
FROM
FactOrderDetail2
WHERE
YEAR(PaymentDate)>='2015'
GROUP BY
MONTH(PaymentDate),YEAR(PaymentDate)
ORDER BY
YEAR(PaymentDate),MONTH(PaymentDate)

报错内容
Error: unexpected numeric constant in:
"                FactOrderDetail2
YEAR(PaymentDate) >= '2015"

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏0 回帖

关键词：RStudio Studio sql语句 stu sql

本人已解决，YEAR(PaymentDate)>='2015' 改成YEAR(PaymentDate)>=2015 即可！