select To_date(Substr(calltime, 1, 8),'yyyymmdd') as ct,CallerNum from "CC_AgentRecord" t group by To_date(Substr(calltime, 1, 8),'yyyymmdd')
group by 里面不能用别名,需要把别名的实际表达式写全。 select To_date(Substr(calltime, 1, 8),'yyyymmdd') as ct,CallerNum from "CC_AgentRecord" t group by To_date(Substr(calltime, 1, 8),'yyyymmdd')
group by To_date(Substr(calltime, 1, 8),'yyyymmdd')
select To_date(Substr(calltime, 1, 8),'yyyymmdd') as ct,CallerNum from "CC_AgentRecord" t group by To_date(Substr(calltime, 1, 8),'yyyymmdd')