Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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£©


Ïà¹ØÎÊ´ð£º

javaÔõôÁ¬½ÓOracle£¬¼±°¡ - Java / JavaÏà¹Ø

private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

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 / »ù´¡ºÍ¹ÜÀí

Ð»Ð»ÌÆÈËÀÏ´óµÄÖ¸µã£¬Ð»Ð»¸÷λ¸ßÊÖµÄÖ¸µã£¡
°²×°10g Enterprise¡£ÉÏÍøÏÂÁËMLDNµÄOracleÊÓÆµ£¬¸ú×ÅÊÓÆµÉϵÄÅäÖÃ×ߣ¬°²×°³É¹¦ÁË£¬µ«ÊÇûÍêÕûµØÅäÖá£
µã»÷½øÈ룺Database Configuration Assistant
1. ´´½¨Êý¾Ý¿â£» ......

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

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