PL/SQLÓαê×ܽá
Óα꣺ָÏò´¦ÀíSQLÓï¾äµÄ»·¾³ÇøÓòµÄÖ¸Õë»ò¾ä±ú
-----|-1 ¾²Ì¬Óαê
|---1.1 ÒþʽÓαê
| ´¦Àí£ºINSERT,DELETE,UPDATE¼°·µ»ØÒ»ÐеÄSELECTÓï¾ä
| ²Ù×÷£ºÓÉPL/SQL×Ô¶¯¶¨Òå²¢Íê³É´ò¿ªÓë¹Ø±Õ¶¯×÷
| ÊôÐÔ£º%FOUND,%NOTFOUND,%ISOPEN,%ROWCOUNT
|---1.2 ÏÔʾÓαê
| ´¦Àí£º·µ»Ø¶àÐеÄSELECTÓï¾ä
| ²Ù×÷£º1.2.1 ÏÔÊ¾ÍÆ½øÑ»·
| --ÉùÃ÷Óαê
| --´ò¿ªÓαê
| --ÍÆ½øÓαê
| --¹Ø±ÕÓαê
| 1.2.2 ×Ô¶¯ÍƽøÑ»·
|
Ïà¹ØÎĵµ£º
Ò»£®Êý¾ÝÍêÕûÐÔ
¾ÍÊÇΪÁË·ÀÖ¹Êý¾Ý¿âÖдæÔÚ²»·ûºÏÓïÒ广¶¨µÄÊý¾Ý£¬ºÍ·ÀÖ¹ÒòÊäÈëÊä³ö´íÎó¶øÔì³ÉµÄÎÞЧ²Ù×÷»òÕß´íÎóÐÅÏ¢¶øÌá³öµÄ£¬Öƶ¨µÄһЩ¶ÔÔª×é¡¢ÊôÐÔºÍÓòµÄÒ»Ð©Ô¼ÊøºÍ¹æ¶¨¡£
½â¾ö°ì·¨ÓÉ£º¹æÔò£¬Ä¬ÈÏÖµ£¬Ô¼ÊøºÍ´¥·¢Æ÷µÈ¡£
¶þ£®Ô¼Êø
......
ÎÄÕÂÀ´Ô´£ºIT¹¤³Ì¼¼ÊõÍø£¬ È«ÎÄÁ´½Ó£ºhttp://www.systhinker.com/html/81/n-11481.html
1.¼ÆËãÿ¸öÈ˵Ä×ܳɼ¨²¢ÅÅÃû
select name,sum(score) as allscore from stuscore group by name order by allscore
2.¼ÆËãÿ¸öÈ˵Ä×ܳɼ¨²¢ÅÅÃû
select distinct t1.name,t1.stuid,t2.allscore from stuscore t1,( select st ......
±íÖÐÓÐһЩ¼Ç¼ÄÚÈÝÖØ¸´£¬Ò²¾ÍÊÇ˵ÕâЩ¼Ç¼³ýÁËID²»Í¬Ö®Í⣬ÆäËûµÄÐÅÏ¢¶¼Ïàͬ¡£ÐèÒª°ÑÖØ¸´µÄ¼Ç¼±£ÁôÒ»Ìõ£¬Ê£ÏµÄɾ³ý
--µÚÒ»ÖÖ·½·¨
delete from temp where id not IN (select min(id) from temp group by col1,col2)
--¶Ôcol1,col2£¬¼´ÒªÉ¾³ýµÄÊý¾Ýcol1,col2Á½¸öÁж¼Ïàͬ,ɾ³ýid´óµÄÐÐ
--µÚ¶þÖÖ·½·¨
with a as
(sel ......
(1)Êý¾Ý¼Ç¼ɸѡ£º
sql="select*fromÊý¾Ý±íwhere×Ö¶ÎÃû=×Ö¶ÎÖµorderby×Ö¶ÎÃû[desc]"
sql="select*fromÊý¾Ý±íwhere×Ö¶ÎÃûlike'%×Ö¶ÎÖµ%'orderby×Ö¶ÎÃû[desc]"
sql="selecttop10*fromÊý¾Ý±íwhere×Ö¶ÎÃûorderby×Ö¶ÎÃû[desc]"
sql="select*fromÊý¾Ý±íwhere×Ö¶ÎÃûin('Öµ1','Öµ2','Öµ3')"
sql="select*fromÊý¾Ý±íwhere× ......
ÎÒÀí½âµÄSQL Server 2005¾µÏñÅäÖÃʵ¼ÊÉϾÍÊÇÓÉÈý¸ö·þÎñÆ÷£¨Ò²¿ÉÒÔÊÇͬһ·þÎñÆ÷µÄÈý¸ö SQL ʵÀý£©×é³ÉµÄÒ»¸ö±£Ö¤Êý¾ÝµÄ»·¾³£¬·Ö±ðÊÇ£ºÖ÷·þÎñÆ÷¡¢´Ó·þÎñÆ÷¡¢¼ûÖ¤·þÎñÆ÷¡£
Ö÷·þÎñÆ÷£ºÊý¾Ý´æ·ÅµÄµØ·½
´Ó·þÎñÆ÷£ºÊý¾Ý±¸·ÝµÄµØ·½£¨¼´£ºÖ÷·þÎñÆ÷µÄ¾µÏñ£©
¼ûÖ¤·þÎñÆ÷£º¶¯Ì¬µ÷ÅäÖ÷/´Ó·þÎñÆ÷µÄµÚÈý·½·þÎñÆ÷
»·¾³½éÉÜ
Ê×ÏȽé ......