Çë½ÌÈçºÎ´ÓÒ»ÕűíÀï¼´È¡ËûµÄijһ×ֶεĺϼÆÖµ£¬Í¬Ê±ÓÖÈ¡ÕâÕűíÒÔÈÕÆÚÅÅÐòµÄijһ×ֶεÄ×î´óÖµ¡£Í¨¹ýÓï¾äÈçºÎʵÏÖ£¬ÇëÖ¸µãͬʱÓÖÈ¡ÕâÕűíÒÔÈÕÆÚÅÅÐòµÄijһ×ֶεÄ×î´óÖµ ²»¶®這¾äµÄÒâ˼£¬½â釋һϰɣ¿ max(ijһ×Ö¶Î)keep(dense_rank last order by ÈÕÆÚ×Ö¶Î) select sum(a) ,max(b) from table;
--×麯Êý select riqi,max(col3) keep(dense_rank last order by col3) ×î´óÖµ, min(col3) keep(dense_rank first order by col3) ×îСֵ, ×Ö¶Î×ÜÖµ=(select sum(col2) from tb) from tb group riqi
oracle 11g °²×° 01092 ´íÎó, ÈÕÖ¾ÐÅÏ¢£º [oracle@linux trace]$ vi alert_orcl.log MMON started with pid=14, OS id=9089 RESETLOGS after incomplete recovery UNTIL CHANGE 522752 Errors in file / ......