摘要:
每天一点点oracle sqlplus / as sysdba [oracle@oracle ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Sun Sep 23 19:52:26 2018 Copyright (c) 1982, 2011, Oracle. All rights reserved. Conne... 阅读全文
摘要:
group by 简单点理解就是根据什么分组 为此 group by job 根据job进行分组 举例:在Oracle当中scott/oracle 下有emp表 进行如下操作 体会order by的魅力 select job,avg(sal),sum(sal),max(sal) from emp g 阅读全文