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

sqlÈý±íÁªºÏ²éѯ,count´ÎÊý

sqlÈý±íÁªºÏ²éѯ
 
a±í£º³Ùµ½¼Ç¼±í---------------------------------------------------------------------------------------------------------------------
ÐÕÃû                 Ö°¹¤±àºÅ                 ³Ùµ½ÈÕÆÚ¼Ç¼   
ÕÅÈý                001                            2009-6-1
Àî˹                002                            2009-6-2
ÕÅÈý                001                            2009-6-2
ÍõÎå                003                            2009-6-4
ÕÅÈý                001                            2009-6-15
Àî˹                002                        


Ïà¹ØÎĵµ£º

pb10Á¬½Óµ½sql server

³õ´ÎʹÓÃpb10µÄÅóÓÑÎÞ·¨Ë³ÀûÁ¬½Óµ½sql server£¬Ò»·½ÃæÃ»ÓÐÁËmssql serverרÓýӿÚÁË£¬ÁíÒ»·½ÃæÊý¾Ý¿â¹ÜÀíϵͳ(DBMS)»»³ÉÁË“OLE DB”£¬ÅäÖÃÆðÀ´Óе㲻˳ÊÖ£¡ÏÂÃæ¾ÍÀ´½éÉÜpb10ÖÐÓÃOLE DBÁ¬½Ósql 2000Êý¾Ý¿â¡£
ÔÚ°²×°pb10µÄʱºòÑ¡Ôñcustom/full·½Ê½°²×°£¨Ä¬Èϵݲװ·½Ê½²»»á°²×°ole db½Ó¿Ú£©£¬next£­¡·Èç¹ûÄãûÓа ......

°²×°|SQL³öÏÖredist.cabºÍsql.cab´íÎó½â¾ö°ì·¨

ÔÚÍøÉÏÏÂÁËÒ»¸ö°æ±¾µÄSQL2008£¬Ò»²½²½°²×°£¬°²×°¹ý³ÌÖÐÓöµ½ÁËredist.cab ºÍSql.cab´íÎ󣬵«»ù±¾¹¦ÄÜ»¹ÊÇÄÜÓ㬵«»¹ÊDz»ÄÜÈÝÈÌ´íÎóµÄ´æÔÚ£¬¾­Ò»·¬ËÑË÷£¬ÖÕÓÚÕÒµ½Á˽â¾ö·½°¸£º
ÏÂÔØmsxml°²×°£¬ÎÒÒ»¿ÚÆø°²×°ÁËmsxml4.0 sp3ºÍmsxml6.0Á½¸öÎļþ
Ϊʲô°²×°Õâ¸ö¶«Î÷ÄÇ?
ÏëÆðÀ´ÁË£¬ÒòΪ°²×°Ê±±¨µÄ´íÎóÊÇÓëÍøÂçÓйØÏµ£¬¶øÎÒµÄwin ......

group_by·ÖÒ³(Sql Server)

×÷Õߣº°½Ê¿Î°
Ò»ÕÅÓÐgroup byºó¿ÉÄܺܶàÖØ¸´ÐУ¬ÕâʱÓÃnot inµÈ»ùÓÚΨһÁеķֲ¼Ëã·¨»á´æÔÚÎÊÌâ¡£
ÎҵĽâ¾ö°ì·¨ÊÇ£º
Ò»ÕűíÓÐÒ»¸öid intµÄÖ÷¼ü£¬¶ÔÆäËüÁнøÐÐgroup by£¬·Öҳ˼ÏëÊÇ£º°Ñmax(id)×ögroup byºóµÄΨһÁУ¬»¹ÊÇÓÃnot inµÄ·Ö²¼Ë¼Ïë¡£
Àý£º
select top 4 sum(int_TZ2_id) as id,dt_TZ2_date,vchar_TZ2_Pin ......

»ùÓÚË÷ÒýµÄSQLÓï¾äÓÅ»¯Ö®½µÁúÊ®°ËÕÆ

1         ǰÑÔ
¿Í·þÒµÎñÊܵ½SQLÓï¾äµÄÓ°Ïì·Ç³£´ó£¬ÔÚ¹æÄ£±È½Ï´óµÄ¾Öµã£¬ÍùÍùÒòΪһ¸öСµÄSQLÓï¾ä²»¹»ÓÅ»¯£¬µ¼ÖÂÊý¾Ý¿âÐÔÄܼ±¾çϽµ£¬Ð¡ÐÍ»úidleËùÊ£ÎÞ¼¸£¬Ó¦Ó÷þÎñÆ÷¶ÏÁ¬¡¢³¬Ê±£¬ÑÏÖØÓ°ÏìÒµÎñµÄÕý³£ÔËÐС£Òò´Ë£¬³ÆµÍЧµÄSQLÓï¾äΪ¿Í·þÒµÎñµÄ‘¶ñÁú’²¢²»¹ý·Ö¡£Êý¾Ý¿âµ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ