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

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×¢È룬¿çÕ¾½Å±¾

sql×¢Èë·ÀÖ¹µÄ·½Ê½£º
1.×î¸ù±¾µÄ°ì·¨¾ÍÊÇʹÓÃÔ¤±àÒëµÄ·½Ê½½øÐÐÊý¾Ý¿â²Ù×÷¡£¼´Ê±Ê¹Ó㿵ķ½Ê½¡£
2.ʹÓùýÂËÀà¡£
·ÀÖ¹¿çÕ¾½Å±¾µÄ·½Ê½£º
1.ÔÚÊý¾Ý¼Èë½×¶Î½øÐйýÂË£¬µ«ÊÇÕâÖÖ·½Ê½»áÊǶªÊ§Ò»Ð©Êý¾Ý¡£
2. ÔÚÊý¾Ýչʾ½×¶Î¡£Ê¹ÓñêÇ©°üº¬£¬innerhtml µÄ·½Ê½¡£ ......

¹ØÓÚSQL avg СÊýµãλÊýµÄ½ØÈ¡

ÔÚȡһ¸öƽ¾ùÖµµÄʱºòÍùÍùÓöµ½Ð¡ÊýµãλÊýµÄ½ØÈ¡¡£
ǰ¼¸ÌìÓöµ½¹ýÕâô¸öÎÊÌ⣬ÔÚKingDee EAS µÄ²éѯ·ÖÎöÆ÷ÀïÃæÈç¹ûÇóijһÎïÁÏµÄÆ½¾ùµ¥¼ÛʱÎÒÕâÑùдµÀ£º
select avg = case sum(bentry.FQuantity) when 0 then 0 else (sum(bentry.famount)/sum(bentry.FQuantity)) end,
´ËÓï¾ä¿´ËÆÃ»Ê²Ã´ÎÊÌ⣬±Ï¾¹ÊÇÇ󯽾ùÖµ£¬¿ÉÊÇÈç¹ûÒªÔ ......

´óÊý¾ÝÁ¿Ï¿ìËÙ»ñÈ¡ SQL Server Êý¾Ý¿â±í¼Ç¼ÊýµÄ·½·¨

ÔÚÊý¾Ý¿âÓ¦ÓõÄÉè¼ÆÖУ¬ÎÒÃÇÍùÍù»áÐèÒª»ñȡijЩ±íµÄ¼Ç¼×ÜÊý£¬ÓÃÓÚÅжϱíµÄ¼Ç¼×ÜÊýÊÇ·ñ¹ý´ó£¬ÊÇ·ñÐèÒª±¸·ÝÊý¾ÝµÈ¡£ÎÒÃÇͨ³£µÄ×ö·¨ÊÇ£ºselect count(*) as c from tableA ¡£È»¶ø¶ÔÓڼǼÊý¾Þ´óµÄ±í£¬ÉÏÊö×ö·¨½«»á·Ç³£ºÄʱ¡£ÔÚDELL 4400 ·þÎñÆ÷ÉÏ×öÊÔÑ飬MS Sqlserver 2000 Êý¾Ý¿â¶ÔÓÚ100Íò¼Ç¼µÄ¼òµ¥Êý¾Ý±íÖ´ÐÐÉÏÊöÓï¾ä£¬Ê± ......

sql checkÔ¼Êø

CHECK Ô¼Êø(CHECK Ô¼Êø:¶¨ÒåÁÐÖпɽÓÊܵÄÊý¾ÝÖµ¡£¿ÉÒÔ½« CHECK Ô¼ÊøÓ¦ÓÃÓÚ¶à¸öÁУ¬Ò²¿ÉÒÔ½«¶à¸ö CHECK Ô¼ÊøÓ¦ÓÃÓÚµ¥¸öÁС£µ±³ýȥij¸ö±íʱ£¬Ò²½«³ýÈ¥ CHECK Ô¼Êø¡£)Ö¸¶¨¿ÉÓɱíÖÐÒ»Áлò¶àÁнÓÊܵÄÊý¾ÝÖµ»ò¸ñʽ¡£ÀýÈ磬¿ÉÒÔÒªÇó authors ±íµÄ zip ÁÐÖ»ÔÊÐíÊäÈëÎåλÊýµÄÊý×ÖÏî¡£
¡¡¡¡
¡¡¡¡¿ÉÒÔΪһ¸ö±í¶¨ÒåÐí¶à CHECK Ô¼Êø¡£¿ ......

OracleµÄsqlÓï¾äÓÅ»¯

 ÔÚѧϰSQLʱ¿´µ½µÄһƬºÜºÃµÄÎÄÕ£¬ÌØÌù³öÀ´ºÍ´ó¼ÒÒ»Æð·ÖÏí£¡
ÎÒÃÇÒª×öµ½²»µ«»áдSQL,»¹Òª×öµ½Ð´³öÐÔÄÜÓÅÁ¼µÄSQLÓï¾ä¡£
£¨1£©Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)£º
OracleµÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬from×Ó¾äÖÐдÔÚ×îºóµÄ±í(»ù´¡±í driving table)½«±»×îÏÈ´¦ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ