有关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版本太低? 求一个PL/SQL的语句 关于同时更新同一条记录的问题 小问题,大学问(答对有分哦) 动态行列转换,遇到新需求! Raid5三块硬盘坏了两块,怎么解决? statspack报告中的语句不知道是哪里产生的,不知大家有没有碰到过??????????????????????????? 如何解决ORA-01110? 求大神帮忙写个SQL语句啊 急用 谢谢 关于oracle的几个简单问题 oracle sql developer软件导出CSV问题 存储过程中,能不能执行 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 ...