我在这里有一条SQL语句:FROM dwh_data JOIN DWH_ACCOMODATIONS ON dwh_data.fk_accomodation = DWH_ACCOMODATIONS.CODE GROUP BY DWH_ACCOMODATIONS.NAME, DATETIME, NIGHTS;D
我正在尝试使用Case和Sum一起运行oracle查询,它给我一个错误,说我缺少正确的括号。 下面的查询, SELECT c.Customer_name, WHEN SUM(status = 'DELIVERED') > 0 THEN 'B'
WHEN SUM(status = 'SUBMITTED') > 0 THEN