收集最近用到的几个oracle函数
//rollup函数:select group_id,job,name,sum(salary) from GROUP_TEST group by rollup(group_id,job,name);//等价于select group_id,job,name,sum(salary) from GROUP_TEST group by group_id,job,nameunion allsele
转载
2017-06-16 18:06:46 ·
166 阅读 ·
0 评论