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

oracleÖÐÈ¥ÖØ¸´¼Ç¼,²»ÓÃdistinct

ÓÃdistinct¹Ø¼ü×ÖÖ»ÄܹýÂ˲éѯ×Ö¶ÎÖÐËùÓмǼÏàͬµÄ£¨¼Ç¼¼¯Ïàͬ£©£¬¶øÈç¹ûÒªÖ¸¶¨Ò»¸ö×Ö¶ÎȴûÓÐЧ¹û£¬ÁíÍâdistinct¹Ø¼ü×Ö»áÅÅÐò£¬Ð§Âʺܵ͡£
select distinct name from t1 ÄÜÏû³ýÖØ¸´¼Ç¼£¬µ«Ö»ÄÜȡһ¸ö×ֶΣ¬ÏÖÔÚҪͬʱȡid,nameÕâ2¸ö×ֶεÄÖµ¡£
select distinct id,name from t1 ¿ÉÒÔÈ¡¶à¸ö×ֶΣ¬µ«Ö»ÄÜÏû³ýÕâ2¸ö×Ö¶Îֵȫ²¿ÏàͬµÄ¼Ç¼
ËùÒÔÓÃdistinct´ï²»µ½ÏëÒªµÄЧ¹û£¬ÓÃgroup by   ¿ÉÒÔ½â¾öÕâ¸öÎÊÌâ¡£
ÀýÈçÒªÏÔʾµÄ×Ö¶ÎΪA¡¢B¡¢CÈý¸ö£¬¶øA×ֶεÄÄÚÈݲ»ÄÜÖØ¸´¿ÉÒÔÓÃÏÂÃæµÄÓï¾ä£º
select A, min(B),min(C),count(*) from [table] where [Ìõ¼þ] group by   A
having [Ìõ¼þ] order by A desc
ΪÁËÏÔʾ±êÌâÍ·ºÃ¿´µã¿ÉÒÔ°Ñselect A, min(B),min(C),count(*) »»³Æselect A as A, min(B) as B,min(C) as C,count(*) as ÖØ¸´´ÎÊý
ÏÔʾ³öÀ´µÄ×ֶκÍÅÅÐò×ֶζ¼Òª°üÀ¨ÔÚgroup by ÖÐ
µ«ÏÔʾ³öÀ´µÄ×ֶΰüÓÐmin,max,count,avg,sumµÈ¾ÛºÏº¯Êýʱ¿ÉÒÔ²»ÔÚgroup by ÖÐ
ÈçÉϾäµÄmin(B),min(C),count(*)
Ò»°ãÌõ¼þдÔÚwhere ºóÃæ
ÓоۺϺ¯ÊýµÄÌõ¼þдÔÚhaving ºóÃæ
Èç¹ûÔÚÉϾäÖÐhaving¼Ó count(*)>1   ¾Í¿ÉÒÔ²é³ö¼Ç¼AµÄÖØ¸´´ÎÊý´óÓÚ1µÄ¼Ç¼
Èç¹ûÔÚÉϾäÖÐhaving¼Ó count(*)>2   ¾Í¿ÉÒÔ²é³ö¼Ç¼AµÄÖØ¸´´ÎÊý´óÓÚ2µÄ¼Ç¼
Èç¹ûÔÚÉϾäÖÐhaving¼Ó count(*)>=1   ¾Í¿ÉÒÔ²é³öËùÓеļǼ£¬µ«Öظ´µÄÖ»ÏÔʾһÌõ£¬²¢ÇÒºóÃæÓÐÏÔÊ¾ÖØ¸´µÄ´ÎÊý----Õâ¾ÍÊÇËùÐèÒªµÄ½á¹û£¬¶øÇÒÓï¾ä¿ÉÒÔͨ¹ýhibernate
ÏÂÃæÓï¾ä¿ÉÒÔ²éѯ³öÄÇЩÊý¾ÝÊÇÖØ¸´µÄ£º
   select ×Ö¶Î1,×Ö¶Î2,count(*) from ±íÃû group by ×Ö¶Î1,×Ö¶Î2 having count(*) > 1
         ½«ÉÏÃæµÄ>ºÅ¸ÄΪ=ºÅ¾Í¿ÉÒÔ²éѯ³öûÓÐÖØ¸´µÄÊý¾ÝÁË¡£
ÀýÈç select count(*) from (select gcmc,gkrq,count(*) from gczbxx_zhao t group by gcmc,gkrq having
count(*)>=1 order by GKRQ)
select * from gczbxx_zhao where viewid in ( select max(viewid) from gczbxx_zhao group by
gcmc ) order by gkrq desc ---»¹ÊÇÕâ¸ö¿ÉÐС£


Ïà¹ØÎĵµ£º

OracleÖÐÐÞ¸ÄSequence·½·¨

OracleÖÐÐÞ¸ÄSequence·½·¨£º¾ÍÊǸıäËüµÄincrement µÝÔö´óС£¬Ëü¿ÉÒÔΪÕýÒ²¿ÉÒÔΪ¸º¡£ÈçÏ£º
SQL> select seq.nextval from dual;
   NEXTVAL
----------
        21
SQL> alter sequence seq increment by 79;
ÐòÁÐÒѸü¸Ä¡£
SQL> select seq.nextval from d ......

Oracle³£ÓÃÈÕÆÚÊý¾Ý¸ñʽ

Ò»¡¢ ³£ÓÃÈÕÆÚÊý¾Ý¸ñʽ
 
1.Y»òYY»òYYY ÄêµÄ×îºóһ룬Á½Î»»òÈýλ
SQL> Select to_char(sysdate,'Y') from dual;
TO_CHAR(SYSDATE,'Y')
--------------------
7
SQL> Select to_char(sysdate,'YY') from dual;
TO_CHAR(SYSDATE,'YY')
---------------------
07
SQL> Select to_char(sysdate,'YYY ......

½â¾öIPµØÖ·±ä»¯ºóOracle 10gÈçºÎ²»ÊÜÓ°Ïì

ÔÚʵ¼ÊµÄ¹¤×÷»·¾³ÖУ¬Ðí¶àÈËΪÁËÊÊÓ¦¿Í»§µÄ»·¾³£¬×ÜÊÇÐèҪƵ·±¸ü¸ÄIPµØÖ·£¬µ«ÊÇÔÚIPµØÖ·±ä»»ºó£¬Oracle 10g¾Í»á³öÏÖÆô¶¯²»Á˵ÄÏÖÏó¡£ÍøÉÏÏà¹ØÎÊÌâµÄ¼¼ÊõÎÄÕ´ó¶àÊýÊÇÕë¶ÔOracle 9i£¬»òÕßÒÔǰµÄOracle 8iµÄ°æ±¾£¬¶ÔÓëOracle 10gµÄ°æ±¾£¬´ó¶àÖ»ÊǽéÉÜÁË´ó¸Å£¬²¢Ã»Óиø³ö¾ßÌåµÄ²½Öè!±¾ÎÄÖУ¬ÎÒÃǽ«Õë¶ÔÕâÒ»ÎÊÌâ¸ø³ö¾ßÌåµÄ½â¾ö² ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ