Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Çë½Ìoracle²éѯÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

Çë½ÌÈçºÎ´ÓÒ»ÕűíÀï¼´È¡ËûµÄijһ×ֶεĺϼÆÖµ£¬Í¬Ê±ÓÖÈ¡ÕâÕűíÒÔÈÕÆÚÅÅÐòµÄijһ×ֶεÄ×î´óÖµ¡£Í¨¹ýÓï¾äÈçºÎʵÏÖ£¬ÇëÖ¸µã
ͬʱÓÖÈ¡ÕâÕűíÒÔÈÕÆÚÅÅÐòµÄijһ×ֶεÄ×î´óÖµ
²»¶®這¾äµÄÒâ˼£¬½â釋һϰɣ¿

max(ijһ×Ö¶Î)keep(dense_rank last order by ÈÕÆÚ×Ö¶Î)

select sum(a) ,max(b) from table;



¶ÔÓÚÒ»¸ö×ֶεÄÖµÀ´Ëµ£¬²»¹ÜËû°´Ê²Ã´ÅÅÐò£¬ÓÐûÓÐÅÅÐò£¬ÄǸö×î´óֵʼÖÕÊÇ×î´óÖµ°¡£¿£¡

ÒýÓÃ
max(ijһ×Ö¶Î)keep(dense_rank last order by ÈÕÆÚ×Ö¶Î)

ÓÖ學習ÁË£¡

SQL code:

--×麯Êý
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




·Ç³£¸Ðл¡££¨wildwave¡¢wkc168£©


Ïà¹ØÎÊ´ð£º

oracle²¢·¢´¦ÀíSOS - Oracle / ¿ª·¢

ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾ­ºÜ³ÉÊìÁË

ÒýÓÃ
oracle ......

[Ô­´´] ORACLE Á¬½Ó×Ö´® - Oracle / ·Ç¼¼ÊõÇø

¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰 
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN ......

oracle °²×° 01092 ´íÎó - Oracle / »ù´¡ºÍ¹ÜÀí

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 / ......

¹ØÓÚOracle´¥·¢Æ÷µÄÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

Ö÷ÒªÏëʵÏÖ£ºÔÚÿÌìµÄ0µã֮ǰ×Ô¶¯½«Êý¾Ý²åÈëÊý¾Ý¿â£¬Ï£Íû´ó¼ÒÖ¸µã£¡
×Ô¶¯²åÈë?Êý¾ÝÔ´ÄÄÀïÀ´µÄ,²åÈ뵽ʲôµØ·½
´¥·¢Æ÷?
Ó¦¸ÃÓÃJOB

Êý¾ÝÔ´ÔÝʱÏëµÄÊǹ̶¨Êý¾Ý£¬²åÈëµ½Ò»Õűí

ÄǾÍÊÇÓÃJOB¶¨Ê±Ö´ÐÐ,´ÓÎļþµ¼ÈëÊ ......

Çë½ÌÒ»¸öoracle¹ÜÀíµÄÎÊÌ⣡ - Oracle / »ù´¡ºÍ¹ÜÀí

·þÎñÆ÷ºǫ́µÄÊý¾Ý¿âÊÇoracle£¬ÔÚ½ñÌìϵͳµÇ¼µÄʱºò±¨¡°µÇ¼²»ÁËÊý¾Ý¿â£¬IOÒì³£¡±£¬½á¹ûÊÇÈ«¹«Ë¾¶¼µÇ²»ÉÏÈ¥£¬ÎÒÖØÆôÁËһϷþÎñÆ÷²ÅºÃÁË£¬ÎÒÏë¿ÉÄÜÊÇÓû§²¢·¢Á¿Ì«´óµÄÔµ¹Ê£¬²»ÖªµÀ¸÷λ´óϺÈÏͬ²»£¿ÓÐʲô½â¾ö°ì·¨Ã»£¿ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ