神马作文网oracle 语句 缺失表达式错误
来源：学生作业帮 编辑：神马作文网作业帮 分类：综合作业 时间：2024/11/10 14:29:12
oracle 语句 缺失表达式错误
create or replace view vw_bus_specialtyassessment3 as
select
t.year ,t.month ,t.assessdeptid ,t1.objectid ,count(t1.objectid),sum(t1.chargescore),
from bus_specialtyassessitem t1,bus_specialtyassessment t
where
t1.specialtyassessitemid=1
order by t.year
哪里不对啊
create or replace view vw_bus_specialtyassessment3 as
select
t.year ,t.month ,t.assessdeptid ,t1.objectid ,count(t1.objectid),sum(t1.chargescore),
from bus_specialtyassessitem t1,bus_specialtyassessment t
where
t1.specialtyassessitemid=1
order by t.year
哪里不对啊
create or replace view vw_bus_specialtyassessment3 as
select
t.year ,t.month ,t.assessdeptid ,t1.objectid ,count(t1.objectid),sum(t1.chargescore)
from bus_specialtyassessitem t1,bus_specialtyassessment t
where
t1.specialtyassessitemid=1
group by t.year ,t.month ,t.assessdeptid ,t1.objectid order by t.yea
select
t.year ,t.month ,t.assessdeptid ,t1.objectid ,count(t1.objectid),sum(t1.chargescore)
from bus_specialtyassessitem t1,bus_specialtyassessment t
where
t1.specialtyassessitemid=1
group by t.year ,t.month ,t.assessdeptid ,t1.objectid order by t.yea