sqlÓï¾äÓÅ»¯3
µÍЧ: (Ë÷ÒýʧЧ)
SELECT … from DEPARTMENT WHERE DEPT_CODE IS NOT NULL;
¸ßЧ: (Ë÷ÒýÓÐЧ)
SELECT … from DEPARTMENT WHERE DEPT_CODE >=0;
£¨27£©×ÜÊÇʹÓÃË÷ÒýµÄµÚÒ»¸öÁУº
Èç¹ûË÷ÒýÊǽ¨Á¢ÔÚ¶à¸öÁÐÉÏ, Ö»ÓÐÔÚËüµÄµÚÒ»¸öÁÐ(leading column)±»where×Ó¾äÒýÓÃʱ,ÓÅ»¯Æ÷²Å»áÑ¡ÔñʹÓøÃË÷Òý¡£ÕâÒ²ÊÇÒ»Ìõ¼òµ¥¶øÖØÒªµÄ¹æÔò£¬µ±½öÒýÓÃË÷ÒýµÄµÚ¶þ¸öÁÐʱ,ÓÅ»¯Æ÷ʹÓÃÁËÈ«±íɨÃè¶øºöÂÔÁËË÷Òý¡£
£¨28£©ÓÃUNION-ALL Ìæ»»UNION ( Èç¹ûÓпÉÄܵϰ)£º
µ±SQLÓï¾äÐèÒªUNIONÁ½¸ö²éѯ½á¹û¼¯ºÏʱ,ÕâÁ½¸ö½á¹û¼¯ºÏ»áÒÔUNION-ALLµÄ·½Ê½±»ºÏ²¢, È»ºóÔÚÊä³ö×îÖÕ½á¹ûǰ½øÐÐÅÅÐò¡£Èç¹ûÓÃUNION ALLÌæ´úUNION,http://www.vstudycn.com ÕâÑùÅÅÐò¾Í²»ÊDZØÒªÁË¡£Ð§ÂʾͻáÒò´ËµÃµ½Ìá¸ß¡£ÐèҪעÒâµÄÊÇ£¬UNION ALL ½«Öظ´Êä³öÁ½¸ö½á¹û¼¯ºÏÖÐÏàͬ¼Ç¼¡£Òò´Ë¸÷λ»¹ÊÇÒª´ÓÒµÎñÐèÇó·ÖÎöʹÓÃUNION ALLµÄ¿ÉÐÐÐÔ. UNION ½«¶Ô½á¹û¼¯ºÏÅÅÐò,Õâ¸ö²Ù×÷»áʹÓõ½SORT_AREA_SIZEÕâ¿éÄÚ´æ¡£¶ÔÓÚÕâ¿éÄÚ´æµÄÓÅ»¯Ò²ÊÇÏàµ±ÖØÒªµÄ¡£ÏÂÃæµÄSQL¿ÉÒÔÓÃÀ´²éѯÅÅÐòµÄÏûºÄÁ¿£º
µÍЧ£º
SELECT ACCT_NUM, BALANCE_AMT
from DEBIT_TRANSACTIONS
WHERE TRAN_DATE = '31-DEC-95'
UNION
SELECT ACCT_NUM, BALANCE_AMT
from DEBIT_TRANSACTIONS
WHERE TRAN_DATE = '31-DEC-95'
¸ßЧ:
SELECT ACCT_NUM, BALANCE_AMT
from DEBIT_TRANSACTIONS
WHERE TRAN_DATE = '31-DEC-95'
UNION ALL
SELECT ACCT_NUM, BALANCE_AMT
from DEBIT_TRANSACTIONS
WHERE TRAN_DATE = '31-DEC-95'
£¨29£©ÓÃWHEREÌæ´úORDER BY£º
ORDER BY ×Ó¾äÖ»ÔÚÁ½ÖÖÑϸñµÄÌõ¼þÏÂʹÓÃË÷Òý¡£
ORDER BYÖÐËùÓеÄÁбØÐë°üº¬ÔÚÏàͬµÄË÷ÒýÖв¢±£³ÖÔÚË÷ÒýÖеÄÅÅÁÐ˳Ðò¡£
ORDER BYÖÐËùÓеÄÁбØÐ붨ÒåΪ·Ç¿Õ¡£
WHERE×Ó¾äʹÓõÄË÷ÒýºÍORDER BY×Ó¾äÖÐËùʹÓõÄË÷Òý²»Äܲ¢ÁС£
ÀýÈç: ±íDEPT°üº¬ÒÔÏÂÁÐ:
DEPT_CODE PK NOT NULL
DEPT_DESC NOT NULL
DEPT_TYPE NULL
µÍЧ: (Ë÷Òý²»±»Ê¹ÓÃ)
SELECT DEPT_CODE&n
Ïà¹ØÎĵµ£º
SQLÓï¾ä²Ù×÷È«¼¯
ÏÂÁÐÓï¾ä²¿·ÖÊÇMssqlÓï¾ä£¬²»¿ÉÒÔÔÚaccessÖÐʹÓá£
SQL·ÖÀࣺ
DDL—Êý¾Ý¶¨ÒåÓïÑÔ(Create£¬Alter£¬Drop£¬DECLARE)
DML—Êý¾Ý²Ù×ÝÓïÑÔ(Select£¬Delete£¬Update£¬Insert)
DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)
Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
Create&n ......
¡¡¡¡¶ÔÓÚOracleµÄµÚÈý·½¿ª·¢¹¤¾ß£¬±¾ÈËÖÓ°®ÓÚQuest SQL Navigator 5.5£¬ÒòΪËü·´Ó¦Ñ¸ËÙ¡¢Ö§³Ö¶à¸öÕ˺ÅͬʱµÇ¼£¬Æ½Ê±Ê¹ÓÃÆðÀ´ºÜ·½±ã¡£
¡¡¡¡²»¹ý£¬·¢ÏÖËüÓиöȱµã£¬¾ÍÊÇÒ»²éѯ´óµãµÄ±í£¬CPU¾ÍÕ¼ÓÃ50%ÒÔÉÏ£¬¸ãµ½Îҵı¾±¾¿ñ½Ð£¬ÎÒÕæÊܲ»ÁË¡£
¡¡¡¡µ½Ëü¹ÙÍø£¬·¢ÏÖÓÐа汾6.2ÁË£¬²»¹ýÏÂÔØÒª×¢²áʲôµÄ£¬ÏÓÂé·³¡£
¡¡¡¡ÍíÉÏ£¬Í» ......
ÔÚȡһ¸öƽ¾ùÖµµÄʱºòÍùÍùÓöµ½Ð¡ÊýµãλÊýµÄ½ØÈ¡¡£
ǰ¼¸ÌìÓöµ½¹ýÕâô¸öÎÊÌ⣬ÔÚKingDee EAS µÄ²éѯ·ÖÎöÆ÷ÀïÃæÈç¹ûÇóijһÎïÁÏµÄÆ½¾ùµ¥¼ÛʱÎÒÕâÑùдµÀ£º
select avg = case sum(bentry.FQuantity) when 0 then 0 else (sum(bentry.famount)/sum(bentry.FQuantity)) end,
´ËÓï¾ä¿´ËÆÃ»Ê²Ã´ÎÊÌ⣬±Ï¾¹ÊÇÇ󯽾ùÖµ£¬¿ÉÊÇÈç¹ûÒªÔ ......
1 :ÆÕͨSQLÓï¾ä¿ÉÒÔÓÃExecÖ´ÐÐ
Àý: Select * from tableName
Exec('select * from tableName')
& ......