Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......

javaÁ¬²»ÉÏoracle£¿ - Java / Java EE

java.sql.SQLException: Io Òì³£: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=186646784)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBErro ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ