oracle 语句 缺失表达式错误
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
哪里不对啊
赞 yokelT 幼苗
共回答了23个问题采纳率：91.3% 举报
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
1年前
4
可能相似的问题
-
1年前1个回答
-
1年前1个回答
-
1年前1个回答
-
1年前1个回答
-
1年前1个回答
-
1年前1个回答
-
1年前1个回答