Çë½ÌÈçºÎ´ÓÒ»ÕűíÀï¼´È¡ËûµÄ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
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡ ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exist ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡