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

sqlÓï¾äÓÅ»¯Ô­Ôò

1.¶àwhere£¬ÉÙhaving
whereÓÃÀ´¹ýÂËÐУ¬havingÓÃÀ´¹ýÂË×é
2.¶àunion all£¬ÉÙunion
unionɾ³ýÁËÖØ¸´µÄÐУ¬Òò´Ë»¨·ÑÁËһЩʱ¼ä
3.¶àExists£¬ÉÙin
ExistsÖ»¼ì²é´æÔÚÐÔ£¬ÐÔÄܱÈinÇ¿ºÜ¶à£¬ÓÐЩÅóÓѲ»»áÓÃExists£¬¾Í¾Ù¸öÀý×Ó
Àý£¬ÏëÒªµÃµ½Óе绰ºÅÂëµÄÈ˵Ļù±¾ÐÅÏ¢£¬table2ÓÐÈßÓàÐÅÏ¢
select * from table1;--(id,name,age)
select * from table2;--(id,phone)
in£º
select * from table1 t1 where t1.id in (select t2.id from table2 t2 where t1.id=t2.id);
Exists£º
select * from table1 t1 where Exists (select 1 from table2 t2 where t1.id=t2.id);
4.ʹÓð󶨱äÁ¿
OracleÊý¾Ý¿âÈí¼þ»á»º´æÒѾ­Ö´ÐеÄsqlÓï¾ä£¬¸´ÓøÃÓï¾ä¿ÉÒÔ¼õÉÙÖ´ÐÐʱ¼ä¡£
¸´ÓÃÊÇÓÐÌõ¼þµÄ£¬sqlÓï¾ä±ØÐëÏàͬ
ÎÊ£ºÔõÑùË㲻ͬ£¿
´ð£ºËæ±ãʲô²»Í¬¶¼Ë㲻ͬ£¬²»¹Üʲô¿Õ¸ñ°¡£¬´óСдʲôµÄ£¬¶¼ÊDz»Í¬µÄ
ÏëÒª¸´ÓÃÓï¾ä£¬½¨ÒéʹÓÃPreparedStatement
½«Óï¾äд³ÉÈçÏÂÐÎʽ£º
insert into XXX(pk_id,column1) values(?,?);
update XXX set column1=? where pk_id=?;
delete from XXX where pk_id=?;
select pk_id,column1 from XXX where pk_id=?;
5.ÉÙÓÃ*
ºÜ¶àÅóÓѺÜϲ»¶ÓÃ*£¬±ÈÈ磺select * from XXX;
Ò»°ãÀ´Ëµ£¬²¢²»ÐèÒªËùÓеÄÊý¾Ý£¬Ö»ÐèҪһЩ£¬ÓеĽö½öÐèÒª1¸ö2¸ö£¬
ÄÃ5WµÄÊý¾ÝÁ¿£¬10¸öÊôÐÔÀ´²âÊÔ:
(ÕâÀïµÄʱ¼äÖ¸µÄÊÇPL/SQL DeveloperÏÔʾËùÓÐÊý¾ÝµÄʱ¼ä)
ʹÓÃselect * from XXX;ƽ¾ùÐèÒª20Ã룬
ʹÓÃselect column1,column2 from XXX;ƽ¾ùÐèÒª12Ãë
(ÎҵĻú×Ó²»ÊǺܺᣡ£¡£)
¶ÔÓÚ¿ª·¢À´Ëµ£¬ÕâÒ»ÌõÊǸöÔÖÄÑ£¬ÖªµÀÊÇÒ»»ØÊ£¬×ö¾ÍÊÇÁíÒ»»ØÊÂÁË
6.·ÖÒ³sql
Ò»°ãµÄ·ÖÒ³sqlÈçÏÂËùʾ£º
sql1:select * from (select t.*,rownum rn from XXX t)where rn>0 and rn <10;
sql2:select * from (select t.*,rownum rn from XXX t where rownum <10)where rn>0;
Õ§¿´Ò»ÏÂÃ»Ê²Ã´Çø±ð£¬Êµ¼ÊÉÏÇø±ðºÜ´ó...125ÍòÌõÊý¾Ý²âÊÔ£¬
sql1ƽ¾ùÐèÒª1.25Ãë(Õ¦ÕâÃ´×¼ÄØ£¿ )
sql2ƽ¾ùÐèÒª... 0.07Ãë
Ô­ÒòÔÚÓÚ£¬×Ó²éѯÖУ¬sql2ÅųýÁË10ÒÔÍâµÄËùÓÐÊý¾Ý
µ±È»ÁË£¬Èç¹û²éѯ×îºó10Ìõ£¬ÄÇЧÂÊÊÇÒ»ÑùµÄ
7.ÄÜÓÃÒ»¾äsql£¬Ç§Íò±ðÓÃ2¾äsql
²»½âÊÍ


Ïà¹ØÎĵµ£º

SybaseµÄSQL Anywhere for BlackBerry

UltraLite®J£ºBlackBerryÉÏÔËÐеÄСÊý¾Ý¿âºÍͬ²½ÒýÇæ
MobiLink £ºÔËÐÐÔÚ·þÎñÆ÷ÉÏÊý¾Ý¿âͬ²½·þÎñÆ÷£¬¿ÉÒÔ°ÑÉ豸ÉϵÄÊý¾Ýͬ²½µ½ºǫ́µÄ¡£°üº¬ÔÚSQL Anywhere 11ÀïÃæ¡£
SQL Anywhere ÊÇÒµÄÚÁìÏȵÄÒÆ¶¯ºÍǶÈëʽÊý¾Ý¿â£¬ÌṩÊý¾Ý¹ÜÀíºÍ½»»»¼¼Êõ£¬ÎªÒ»Ïß»·¾³ÖеÄÓ¦ÓóÌÐòÌṩ֧³Ö¡£
SQL Anywhere רΪ²»¾ß±¸ÏÖ³¡ IT Ö§³Ö¡¢Ô ......

sql having ºÍwhereµÄÇø±ð

  ×î½üÔÚѧϰoracleµÄʱºòÓöµ½Ò»¸öÎÊÌ⣬ÀÏÊÇŪ²»Çå³þwhere ºÍhavingµÄÇø±ð£¬ÔÚÍøÉϲéÒ»²é£¬¸Ð¾õ»¹¿ÉÒÔ£¬°ÑÒÔÏÂÎÒ²éµÄ×ÊÁÏÍÆ¼ö¸ø´ó¼Ò¡£
ÔÚselect Óï¾äÖпÉÒÔʹÓÃgroup by ×Ӿ佫Ðл®·Ö³É½ÏСµÄ×飬Ȼºó£¬Ê¹ÓþÛ×麯Êý·µ»ØÃ¿Ò»¸ö×éµÄ»ã×ÜÐÅÏ¢£¬ÁíÍ⣬¿ÉÒÔʹÓÃhaving×Ó¾äÏÞÖÆ·µ»ØµÄ½á¹û¼¯¡£group&n ......

SQL Server CE·þÎñÆ÷¶ËºÍ¿Í»§¶Ë°²×°ÅäÖÃѧϰ±Ê¼Ç

 
SQL Server 2005 CE¿ª·¢»·¾³½éÉÜ£º
       ×î½üѧϰʹÓÃSQL Server 2005 Compact Edition½øÐÐÊý¾Ý´æ´¢£¬ÔÚѧϰµÄ¹ý³ÌÖз¢ÏÖ£¬Ê¹ÓÃSQL Server2005 management Studio´´½¨Êý¾Ý¿âʱ£¬ÔÚ“·þÎñÆ÷ÀàÐÍ”ÏÂÀ­ÁбíÖÐûÓГSQL Server Compact Edition”Ñ¡Ïî¡£ÒòΪÎÄÕ ......

³£ÓõÄWORDPRESS µÄSQLÓï¾ä


ÏÂÃæËùÓеÄSQLÓï¾ä¶¼ÊÇÕë¶Ôǰ׺Ϊwp_µÄ±í£¬Èç¹ûÄãµÄ±íǰ׺²»ÊÇwp_£¬Çë×öÏàÓ¦µÄÐÞ¸Ä
1.¸ü¸Äwordpress°²×°ºÍÊ×Ò³µØÖ·
Èç¹ûÄã¸ü»»ÓòÃû»òÕß°ÑwordpressµÄ°²×°Ä¿Â¼½øÐÐÁ˱䶯¾ÍÐèÒª½øÐÐÐ޸ģ¬
UPDATE wp_options SET option_value = replace(option_value, ‘¾ÉÍøÖ·’, ‘ÐÂÍøÖ·’) WHERE option_name ......

PL/SQL Best Practice On BULK COLLECT

On BULK COLLECT
By Steven Feuerstein Oracle ACE
Best practices for knowing your LIMIT and kicking %NOTFOUND
I have started using BULK COLLECT whenever I need to fetch large volumes of data. This has caused me some trouble with my DBA, however. He is complaining that although my programs mig ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ