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

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


Ïà¹ØÎÊ´ð£º

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

server 2000Êý¾Ý×ªÒÆµ½oracle - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔ­À´oracleÀïµÄÔ­ÓеÄÊý¾Ý¿â,Ö»ÄÜн¨

ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......

Ò»¸öpl/sqlÎÊÌâ - Oracle / ¿ª·¢

ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
  declare
  TYPE test_rec IS record(
  code varchar(10),
  name varchar(30)
  );
  v_book test_rec;
    ......

sqlÓÅ»¯ - Oracle / »ù´¡ºÍ¹ÜÀí

select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' 
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......

ÅäÖû·¾³±äÁ¿oracleÔÚ XP - Oracle / »ù´¡ºÍ¹ÜÀí

ÅäÖû·¾³±äÁ¿oracleÔÚ XP
 ÐüÉÍ·Ö£º105 - ½â¾öʱ¼ä£º2008-9-23 23:39 
ÎÒÖ»°Ñoracle×°ÔÚÁËE:\oracleÖÐ
»·¾³±äÁ¿²»ÖªµÀÈçºÎÅäÖÃ.

XPϰ²×°ORACLE ûÓÐÐèÒªÅäÖõĻ·¾³±äÁ¿
¿ÉÒÔͨ¹ýEMÅäÖÃÏ·þÎñÃûº ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ