我正在使用Oracle示例:2) 1,2,3,5,11第一个例子是我遇到的问题。我正在编写一个select查询,如: SELECT * from Table where Value IN (1,2,3,6-8,9-11)SELECT * from Table where Value IN (1,2,3,6,7
],
+ CASE WHEN Datepart(dw, b.date_received)) = 1 THEN 1 ELSE 0 join TX b on b.id on a.id
selectTime_Spent >= 9 then 100.0 else 0 end) as more_than_9_day_pe