请教关于ORA-00936: 缺少表达式 的问题！

[asdsadfe]

Select T1.count(*),T1.sum(decode(errorcode,0,1,0)) from

glc_location_msg_200909 T1 where 1=1 And
left join(
select tvcityid,servicecode from glc_location_msg_200909 T2 where 1=1 group by tvcityid,servicecode
) on T1.tvcityid = T2.tvcityid and T1.servicecode=T2.servicecode


上面sql执行中，T1.count(*）这里报ORA-00936 错误，请问如何修改？

[cosio]

改为:count(T1.*)

[asdsadfe]

Select T1.count(tvcityid,servicecode),T1.sum(decode(errorcode,0,1,0)) from

glc_location_msg_200909 T1
left join(
select t2.tvcityid,t2.servicecode from glc_location_msg_200909 T2 group by tvcityid,servicecode
) on T1.tvcityid = T2.tvcityid and T1.servicecode=T2.servicecode

这个执行时，报 T2.servicecode ，无效的标识符 ，请教如何修改？谢谢了。。

[asdsadfe]

[Quote=引用 1 楼 cosio 的回复:]
SQL code改为:count(T1.*)
[/Quote]
试过，还是报错。。ORA-01747

[cosio]

[Quote=引用 2 楼 chinazmg 的回复:]
Select  T1.count(tvcityid,servicecode),T1.sum(decode(errorcode,0,1,0)) from

glc_location_msg_200909 T1
left join(
select t2.tvcityid,t2.servicecode from glc_location_msg_200909  T2  group by tvcityid,servicecode
) on T1.tvcityid = T2.tvcityid and T1.servicecode=T2.servicecode 

这个执行时，报 T2.servicecode ，无效的标识符 ，请教如何修改？谢谢了。。
[/Quote]

Select count(T1.*),count(A.servicecode),T1.sum(decode(errorcode,0,1,0)) from

glc_location_msg_200909 T1
left join(
select t2.tvcityid,t2.servicecode from glc_location_msg_200909 T2 group by tvcityid,servicecode
) A on T1.tvcityid = A.tvcityid and T1.servicecode=A.servicecode

[cosio]

Select  count(T1.tvcityid),sum(decode(T1.errorcode,0,1,0)) from 
glc_location_msg_200909 T1 
left join( 
select t2.tvcityid,t2.servicecode from glc_location_msg_200909  T2  group by tvcityid,servicecode 
) A on T1.tvcityid = A.tvcityid and T1.servicecode=A.servicecode  

因为表两一个,所以用count(*)就会提示ORA-01747 ,因为字段一样要指定那个表的字段才行!

[huangdh12]

说实话 这条语句看的我很迷糊。。。。count（t1.*）到底用意何在？？

[ty_tarena_pger]

SUM