Oracle sql报错,求解!!!!
sql如下:
select trunc(tdate),
sum(nvl(who_look, 0)),
min(who_look_1_1),
sum(nvl(who_look_1_2, 0)),
sum(nvl(who_look_1_3, 0)),
min(who_look_2_1),
sum(nvl(who_look_2_2, 0)),
sum(nvl(who_look_2_3, 0)),
sum(nvl(profile, 0)),
min(profile_1_1),
sum(nvl(profile_1_2, 0)),
sum(nvl(profile_1_3, 0)),
min(profile_2_1),
sum(nvl(profile_2_2, 0)),
sum(nvl(profile_2_3, 0)),
sum(nvl(ICON, 0)),
min(ICON_1_1),
sum(nvl(ICON_1_2, 0)),
sum(nvl(ICON_1_3, 0)),
min(ICON_2_1),
sum(nvl(ICON_2_2, 0)),
sum(nvl(ICON_2_3, 0)),
sum(nvl(BANNER, 0)),
min(BANNER_1_1),
sum(nvl(BANNER_1_2, 0)),
sum(nvl(BANNER_1_3, 0)),
min(BANNER_2_1),
sum(nvl(BANNER_2_2, 0)),
sum(nvl(BANNER_2_3, 0)),
min(KXBY_1),
sum(nvl(KXBY_2, 0)),
sum(nvl(KXBY_3, 0)),
sum(nvl(PHOTO, 0)),
min(PHOTO_1_1),
sum(nvl(PHOTO_1_2, 0)),
sum(nvl(PHOTO_1_3, 0)),
min(PHOTO_2_1),
sum(nvl(PHOTO_2_2, 0)),
sum(nvl(PHOTO_2_3, 0))
from STATIST_VIP_BYSOURCE_ALL
where TDATE >= trunc(sysdate)
and tdate < trunc(sysdate +1)
group by trunc(tdate)
order by trunc(tdate)
报错如图:,谢谢
追问:表结构就是那些字段都是number类型的,太多了,列不出来字段是对的配置文件里面内容挺多的