Oracle数据分组实现.docVIP

Oracle数据分组实现 Oracle鏁版嵁鍒嗙粍瀹炵幇 viewspace-661576 杩欓噷鎵€璇寸殑鍒嗙粍骞堕潪绠€鍗曠殑group by褰㈠紡鐨勫垎缁勶紝鑰屾槸瀹炵幇濡備綍鐢ㄦ潵group by鐨勬暟鎹瀯寤恒€傛垜浠粡甯搁亣鍒扮殑灏辨槸鎸夌収鏌愪簺瀛楁鎴栬〃杈惧紡灏嗙粨鏋滈泦鍒掑垎涓鸿嫢骞蹭釜涓嶅悓鐨勫垎缁勶紝浠ヤ究浜庢寜缁勮繘琛屾暟鎹搷浣溿€傛瘮濡傦紝鎸夌収閮ㄩ棬鏉ョ粺璁′汉鏁般€傛鏃讹紝閮ㄩ棬灏辨槸涓€涓垎缁勫瓧娈点€? 浣嗘槸锛屾湁鏃跺€欐儏鍐靛苟涓嶆槸閭ｄ箞绠€鍗曘€傛瘮濡傚吀鍨嬬殑杩炵画鍙风爜闂锛岃繖涓棶棰樺強鍏跺彉绉嶇粡甯镐細鍦ㄥ悇澶ц鍧涗笂琚彁鍑恒€傝闂鐨勬弿杩板涓嬶細鏈変竴缁勯潪杩炵画鐨勬暟瀛楋紝鍏朵腑鐨勬煇浜涙暟瀛楁槸灞€閮ㄨ繛缁殑锛岀幇鍦ㄨ姹傚嚭杩欎簺灞€閮ㄨ繛缁暟瀛楃殑鏈€澶ф渶灏忓€笺€傝繖閲屾殏涓斾笉璇村叿浣撹В鍐虫柟寮忥紝鍏堟妸鎴戞墍閬囧埌鐨勮繖浜涚壒娈婂垎缁勫垪涓惧嚭鏉ワ紝鐒跺悗涓€涓€鎻愬嚭銆? 鎬诲叡鏈変互涓嬪嚑涓細 虏 椤哄簭鐩稿叧鍒嗙粍銆備繚鎸佺幇鏈夐『搴忎笉鍙樼殑鎯呭喌涓嬶紝瀵圭浉鍚屾暟鍊艰繘琛屽垎缁勩€? 虏 杩炵画鍙风爜鍒嗙粍銆傛寜鏁板€奸『搴忔帓搴忓悗锛屽杩炵画鐨勬暟鍊艰繘琛屽垎缁勩€? 虏 鍒嗙粍閲嶆帓銆傚鍒嗙粍杩涜鎺掑簭銆? 虏 濂栭」鍚嶉鍒嗛厤闂銆傛寜涓嶅悓鐨勫椤瑰悕棰濊繘琛屽垎缁勩€? 虏 闈炴爣鍑嗗崟浣嶇殑鍒嗙粍闂銆傛寜N涓皬鏃舵垨N鍒嗛挓绛夋柟寮忓垎缁勩€? 娴嬭瘯鏁版嵁锛坰cott.emp琛級锛? SQL select * from scott.emp 2 / EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO ----- ---------- --------- ----- ----------- --------- --------- ------ 7369 SMITH CLERK 12-17 800.00 20 7499 ALLEN SALESMAN 2-20 1600.00 300.00 30 7521 WARD SALESMAN 2-22 1250.00 500.00 30 7566 JONES MANAGER 4-2 2975.00 20 7654 MARTIN SALESMAN 9-28 1250.00 1400.00 30 7698 BLAKE MANAGER 5-1 2850.00 30 7782 CLARK MANAGER 6-9 2450.00 10 7788 SCOTT ANALYST 4-19 4000.00 20 7839 KING PRESIDENT 1981-11-17 5000.00 10 7844 TURNER SALESMAN 9-8 1500.00 0.00 30 7876 ADAMS CLERK 5-23 1100.00 20 7900 JAMES CLERK 12-3 950.00 30 7902 FORD ANALYST 12-3 3000.00 20 7934 MILLER CLERK 1-23 1300.00 10 14 rows selected 涓€銆? 椤哄簭鐩稿叧鍒嗙粍 鍗冲鏋滈亣鍒拌繛缁浉鍚岀殑鏁板氨璁や负鏄竴涓垎缁勶紝涓€鏃﹀嚭鐜颁笉鍚岀殑鏁板嵆璁や负鏄笅涓€涓垎缁勩€傚嵆浣垮悗缁張鍑虹幇浜嗙浉鍚岀殑鏁颁篃涓嶈兘璺熷墠闈㈢殑鏁拌涓烘槸涓€涓垎缁勩€? 姣斿浠ヤ笅鏁板垪锛?