OracleÂËÖØÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí
¼ÙÈçÒ»ÕűíÖÐÓÐ2¸ö×ֶΣ¬·Ö±ðÊÇnameºÍage ÈçºÎ°ÑÕâÕűíÖÐÏàͬµÄÖØ¸´ÐйýÂ˵ôÄØ distinct(t.name,t.age)ÊDZ¨´íµÄ£¬Ö»ÄÜdistinctÒ»¸ö×Ö¶Î ÓÐʲô±ðµÄ°ì·¨°¡ ×ÔÁ¬½Ó¿É²»¿ÉÒÔ°¡ ûÊÔ¹ý
select distinct t.name, t.age from table distinctËü²»ÊǺ¯Êý£¬ËüÖ»ÊÇselectÓï¾äÖÐÓÃÓÚÂËÖØµÄÒ»¸ö¹Ø¼ü×Ö£¬ËùÒÔ²»ÄÜд³Éº¯Êýµ÷ÓõÄÐÎʽ£ºdistinct(t.name,t.age)£¬Ó¦Ð´³Éselect distinct t.name,t.age from student; distinct»á¶ÔºóÃæµÄËùÓÐ×ֶνøÐÐ×éºÏÆðÀ´¹ýÂË£¬ËùÒÔÂ¥ÉÏÕý½â!ÒýÓà select distinct t.name, t.age from table distinct Ö»ÄܹýÂË nameºÍage ÍêȫһÑùµÄ.. ------------------------------------------------------------------------------ Blog£º http://blog.csdn.net/tianlesoftware ÍøÉÏ×ÊÔ´£º http://tianlesoftware.download.csdn.net Ïà¹ØÊÓÆµ£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx DBA1 Ⱥ£º62697716(Âú); DBA2 Ⱥ£º62697977
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£ ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£ ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£ ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨ ÒýÓà °²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql declare TYPE test_rec IS record( code varchar(10), name varchar(30) ); v_book test_rec; ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
ÅäÖû·¾³±äÁ¿oracleÔÚ XP ÐüÉÍ·Ö£º105 - ½â¾öʱ¼ä£º2008-9-23 23:39 ÎÒÖ»°Ñoracle×°ÔÚÁËE:\oracleÖÐ »·¾³±äÁ¿²»ÖªµÀÈçºÎÅäÖÃ. XPϰ²×°ORACLE ûÓÐÐèÒªÅäÖõĻ·¾³±äÁ¿ ¿ÉÒÔͨ¹ýEMÅäÖÃÏ·þÎñÃûº ......