有关group by 的一个问题,请帮忙解答。 group by to_char(register_time,'yyyy-mm-dd') 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 如题意所示group by get_clinicnum_by_day_office( '10300', to_char(register_time,'yyyymmdd')),get_clinicnum_by_day_office( '10200', to_char(register_time,'yyyymmdd')),(get_clinicnum_by_day_office( '10300', to_char(register_time,'yyyymmdd')) + get_clinicnum_by_day_office( '10200',to_char(register_time,'yyyymmdd'))),to_char(register_time,'yyyy-mm-dd') select get_clinicnum_by_day_office( '10300', to_char(register_time,'yyyymmdd')) AS 科1, get_clinicnum_by_day_office( '10200', to_char(register_time,'yyyymmdd'))AS 科2, (get_clinicnum_by_day_office( '10300', to_char(register_time,'yyyymmdd')) + get_clinicnum_by_day_office( '10200',to_char(register_time,'yyyymmdd'))) as sum2 , to_char(register_time,'yyyy-mm-dd') as todayfrom register_infogroup by to_char(register_time,'yyyy-mm-dd') 用distinct !select distinct get_clinicnum_by_day_office( '10300', to_char(register_time,'yyyymmdd')) AS 科1, get_clinicnum_by_day_office( '10200', to_char(register_time,'yyyymmdd'))AS 科2, (get_clinicnum_by_day_office( '10300', to_char(register_time,'yyyymmdd')) + get_clinicnum_by_day_office( '10200',to_char(register_time,'yyyymmdd'))) as sum2 , to_char(register_time,'yyyy-mm-dd') as todayfrom register_info 这样虽然是搞定了。但是,我想问的是, 在group by后面是不是只能是 数据表的原来的字段。 好像用别名不行,但可以用函数,比如to_char(register_time,'yyyy-mm-dd') ,get_clinicnum_by_day_office( '10200', to_char(register_time,'yyyymmdd')) 等。 select ... from ( select ... from ... ) a --from中的子查询就是你原先的查询 group by ... 我的Oracle(8.1.7)可以使用group by function(),... 是不是你的Oracle版本太低? 有没有什么插件或第三方软件可以实时监控库中表的变动 (紧急)请教一个在线生产系统的在用表的数据迁移和数据更新的问题(不能停应用),请高手不吝赐教,谢谢! 动态sql语句关于select的 数据库重复 谁在用PL\SQL Developer6.0.3,切换输入法就死,气死我了 我的oracle 数据库突然在网络中客户端oem中无法控制了 请教各位大虾:ORACLE中删除表引起的碎片问题? oracle9i恢复,急,在线等 oracle产品的价格问题 HELP!! 在线等待 触发器的问题 存储过程中,能不能执行 create 命令? 请各位帮忙解决一次 SQL 语句!
group by get_clinicnum_by_day_office( '10300', to_char(register_time,'yyyymmdd')),get_clinicnum_by_day_office( '10200', to_char(register_time,'yyyymmdd')),(get_clinicnum_by_day_office( '10300', to_char(register_time,'yyyymmdd')) + get_clinicnum_by_day_office( '10200',to_char(register_time,'yyyymmdd'))),to_char(register_time,'yyyy-mm-dd')
get_clinicnum_by_day_office( '10300', to_char(register_time,'yyyymmdd')) AS 科1,
get_clinicnum_by_day_office( '10200', to_char(register_time,'yyyymmdd'))AS 科2,
(get_clinicnum_by_day_office( '10300', to_char(register_time,'yyyymmdd')) + get_clinicnum_by_day_office( '10200',to_char(register_time,'yyyymmdd'))) as sum2 ,
to_char(register_time,'yyyy-mm-dd') as todayfrom register_info
group by to_char(register_time,'yyyy-mm-dd')
get_clinicnum_by_day_office( '10200', to_char(register_time,'yyyymmdd'))AS 科2,
(get_clinicnum_by_day_office( '10300', to_char(register_time,'yyyymmdd')) + get_clinicnum_by_day_office( '10200',to_char(register_time,'yyyymmdd'))) as sum2 ,
to_char(register_time,'yyyy-mm-dd') as today
from register_info
但是,我想问的是, 在group by后面是不是只能是 数据表的原来的字段。
from ( select ... from ... ) a --from中的子查询就是你原先的查询
group by ...