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

SQLÓïÑÔ»ù´¡£¨4£©

UNION½«Á½¸ö»òÁ½¸öÒÔÉϵIJéѯ½á¹ûºÏ²¢ÎªÒ»¸ö½á¹û¼¯£¬ËüÓëʹÓÃÁ¬½Ó²éѯºÏ²¢Á½¸ö±íµÄÁÐÊDz»Í¬µÄ£¬Ê¹
ÓÃUNIONºÏ²¢²éѯ±ØÐë×ñÊØ£º1ÁеÄÊýÄ¿ºÍ˳Ðò±ØÐëÒ»Ö£»2Êý¾ÝµÄÀàÐͱØÐë¼æÈÝ¡£
select Óï¾ä
UNION [all]
select Óï¾ä
¿ÉÒÔ¿´µ½£¬Ö»Òª¶ÔÓ¦×ֶεÄÀàÐÍÏàͬ¾Í¿ÉÒÔÍê³ÉºÏ²¢²Ù×÷£¬µ«ÊÇΪÁËÓÐÒâÒ壬Á½¸ö²éѯµÄ½á¹ûÓ¦¸ÃΪÏàͬ
µÄº¬Ò壬·ñÔòûÓÐÒâÒå¡£
½á¹û×Ö¶ÎÃû³ÆºÍunion֮ǰµÄ×Ö¶ÎÃû³ÆÏàͬ£¬Ä¬ÈÏÇé¿öÏÂɾ³ý½á¹û¼¯ÖеÄÖØ¸´¼Ç¼£¬Èç¹ûÏ£Íû±£ÁôËùÓмÇ
¼£¬Ôò±ØÐëʹÓÃall¹Ø¼ü×Ö¡£
ʹÓÃunionʱµ¥¶ÀµÄselectÓï¾ä²»Äܰüº¬×Ô¼ºµÄorder by»òcompute×Ӿ䣬ֻÄÜÔÚ×îºóʹÓÃorder byºÍ
computeÓï¾ä£¬¶Ô×îÖÕ½á¹û¼¯½øÐÐ×÷Óá£
ÈôÐèÒª¶Ô²éѯ½á¹û½øÐзÖ×éÒÔ¼°ÔÚ·Ö×éºó¶Ô½á¹ûʹÓÃhaving×Ӿ佸ÐйýÂË£¬Ôò±ØÐëÔÚµ¥¶ÀµÄselectÓï¾äÖÐ
Ö¸¶¨group byºÍhaving×Ӿ䡣
²éѯ¼ÆËã»úϵµÄѧÉú»òÕßÄêÁä²»´óÓÚ19ËêµÄѧÉú£¬²¢°´ÄêÁäµ¹ÅÅÐò
select * from student where sdept="¼ÆËã»ú"
union
select * from student where sage<=19
order by sage desc
Á¬½Ó²éѯ
¸ù¾ÝÊý¾Ý±íµÄÂß¼­¹ØÏµ´ÓÁ½¸ö»ò¶à¸öÊý¾Ý±íÖмìË÷Êý¾Ý
¶¨ÒåÊý¾Ý±íÖ®¼äµÄ¹ØÁª·½Ê½£º1Ö¸¶¨ÓÃÓÚÁª½áµÄ×ֶΣ¬µäÐ͵ÄÁª½áÌõ¼þÊÇÔÚÒ»¸öÊý¾Ý±íÖÐÖ¸¶¨Íâ¼ü£¬Í¬ÊÂ
ÔÚÁíÒ»¸öÊý¾Ý±íÖÐÖ¸¶¨ÓëÆä¹ØÁªµÄÖ÷¼ü¡£2ÔÚselectÓï¾äÖÐÖ¸¶¨±È½Ï¸÷×Ö¶ÎֵʱҪʹÓõÄÂß¼­ÔËËã·û¡£
Áª½áµÄÀàÐÍ£ºÄÚÁª½á£»ÍâÁª½á£¨×óÏòÍâÁ¬½Ó£¬ÓÒÏòÍâÁ¬½Ó£¬ÍêÕûÍâÁ¬½Ó£©£»½»²æÁ¬½Ó
ÄÚÁª½á¸ñʽ£ºÊý¾Ý±í1 inner join Êý¾Ý±í2 on Áª½á±í´ïʽ
Ö¸¶¨·µ»ØÁ½¸ö±íÖÐËùÓÐÆ¥ÅäµÄÐС£innerÊÇȱʡµÄÁ¬½Ó·½Ê½
ÍâÁ¬½Ó£ºÊý¾Ý±í1 left (outer) join Êý¾Ý±í2 on Áª½á±í´ïʽ
        ×óÁª½áÊý¾Ý±í1µÄËùÓмǼ¶¼·µ»Ø£¬ÓÒ±ß×Ö¶ÎûÓÐÆ¥ÅäʱΪ¿ÕÖµ¡£
        Êý¾Ý±í1 right (outer) join Êý¾Ý±í2 on Áª½á±í´ïʽ
        ÓÒÁª½áÊý¾Ý±í2µÄËùÓмǼ¶¼·µ»Ø£¬×ó±ß×Ö¶ÎûÓÐÆ¥ÅäʱΪ¿ÕÖµ¡£
ÍêÕûÁª½á£ºÊý¾Ý±í1 full join Êý¾Ý±í2 on Áª½á±í´ïʽ
½á¹û¼¯°üÀ¨ËùÓмǼ£¬Ã»ÓÐÆ¥Åä¼Ç¼ʱÔò½«ÁíÒ»Êý¾Ý±íÑ¡ÔñÁбí×Ö¶ÎÖÿա£
½»²æÁª½á£ºÊý¾Ý±í1 cross join Êý¾Ý±í2 £¨Ã»ÓÐwhere×Ó¾äµÄÇé¿öÏ·µ»ØµÑ¿¨¶û³Ë»ý£©
ǶÌײéѯ£ºÍâ²ã²éѯÊÇÖ÷²éѯ£¬ÄÚ²ã²éѯÊÇ×Ó²éѯ¡£SQLÔÊÐí¶à²ãǶÌ×£¬order by ×Ó¾äÖ»ÄܶÔ×îÖÕ²éѯ½á
¹û½øÐÐÅÅÐò¡£
±È½Ï³£ÓõÄ×Ó²éѯ£ºwhere ±í´ïʽ[not] in (×Ó²éѯ)
&


Ïà¹ØÎĵµ£º

º½¿Õ¹«Ë¾¹ÜÀíϵͳ(VC++ ÓëSQL 2005)

ϵͳ»·¾³£ºWindows 7
Èí¼þ»·¾³£ºVisual C++ 2008 SP1 +SQL Server 2005
±¾´ÎÄ¿µÄ£º±àдһ¸öº½¿Õ¹ÜÀíϵͳ
      ÕâÊÇÊý¾Ý¿â¿Î³ÌÉè¼ÆµÄ³É¹û£¬ËäÈ»³É¼¨²»¼Ñ£¬µ«ÊÇ×÷ΪÎÒÓÃVC++ ÒÔÀ´±àдµÄ×î´ó³ÌÐò»¹ÊÇ´«µ½ÍøÉÏ£¬ÒÔ¹©²Î¿¼¡£ÓÃVC++ ×öÊý¾Ý¿âÉè¼Æ²¢²»ÈÝÒ×£¬µ«Ò²²»ÊDz»¿ÉÄÜ¡£ÒÔÏÂÊÇÎҵijÌÐò½çÃæ£¬ºóÃæ ......

eclipse ¹ØÁª sql server µÄJDBCÎÊÌâ

eclipse ¹ØÁª sql server µÄJDBCÎÊÌâ
±à³ÌÔËÐкóÌáʾ£º
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
ÉÏÍø²éÁË£¬ÓеÄ˵ÔÚ»·¾³±äÁ¿ÀïµÄclasspathÌí¼Ó JDBCÀïµÄ3¸öjarÎļþ¾Í¿ÉÒÔ£¬µ«ÊÇʹÓúó»¹ÊDz»ÐС£
ºóÀ´²ÅÖªµÀ½â¾ö·½·¨£º
°ü×ÊÔ´¹ÜÀíÆ÷-->°üÃûÓÒ¼ü"¹¹½¨Â·¾¶"--> ......

oralce sqlÓÅ»¯34Ìõ

ÎÒÃÇÒª×öµ½²»µ«»áдSQL,»¹Òª×öµ½Ð´³öÐÔÄÜÓÅÁ¼µÄSQL,ÒÔÏÂΪ±ÊÕßѧϰ¡¢ÕªÂ¼¡¢²¢»ã×ܲ¿·Ö×ÊÁÏÓë´ó¼Ò·ÖÏí£¡
£¨1£©      Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)£º
ORACLE µÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬from×Ó¾äÖÐдÔÚ×îºóµÄ±í(»ù´¡±í driving table)½«±»×îÏÈ´¦Àí£¬ÔÚfrom× ......

Èí¼þ²âÊÔÖг£ÓõÄSQLÓï¾ä

²éѯÓï¾ä
Óï·¨¸ñʽ£º
SELECT
    [ALL | DISTINCT | DISTINCTROW ]
      [HIGH_PRIORITY]
      [STRAIGHT_JOIN]
      [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_
      [SQL_CACHE | SQL_ ......

SQLÓïÑÔ»ù´¡£¨3£©

GROUP BY×Ó¾ä
Ö¸¶¨²éѯ½á¹ûµÄ·Ö×éÌõ¼þ
Óï·¨£ºGROUP BY [ALL] group_by_expression_r_r [,n]
      [WITH{CUBE|ROLLUP}]
group_by_expression_r_rÖ¸Ã÷·Ö×éÌõ¼þ£¬Í¨³£ÊÇÒ»¸öÁÐÃû£¬µ«²»ÄÜÊÇÁеıðÃû¡£
ALL·µ»ØËùÓвéѯ½á¹ûµÄ×éºÏ¡£Èç¹ûûÓÐÂú×ãwhere×Ó¾äµÄÊý¾ÝÔòÓÉNULLÖµ¹¹³ÉÊý¾Ý¡£ALLµÄÑ¡Ïî²»Ä ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ