**¿âÁ¬½ÓÎÊÌâ

ʱ¼ä£º2014.02.24 ·¢²¼ÈË£º±»·ç´µ¹ýµÄº£°¶

**¿âÁ¬½ÓÎÊÌâ

Òѽâ¾öÎÊÌâ

¹È¸è±»·ç´µ¹ýµÄº£°¶Óû§ÔÚ2014.02.24Ìá½»Á˹ØÓÚ¡°Ãëɱ**¿âÁ¬½ÓÎÊÌ⡱µÄÌáÎÊ£¬»¶Ó­´ó¼ÒÓ¿Ô¾·¢±í×Ô¼ºµÄ¹Ûµã¡£Ä¿Ç°¹²ÓÐ5¸ö»Ø´ð£¬×îºó¸üÐÂÓÚ2025-02-25T16:25:34¡£

**LECTmmliid,max(M.PUdate)asPUdate,max(M.wsc_name)aswsc_name,count(*)ASbookTimesFROMmm_bookdetailDINNERJOINmm_bookmasterM

ONd.MCBKCode=M.MCBKCodegroupbymmliid


mm_bookdetail±íÓÐ849522Ìõ¼Ç¼£¬mm_bookmasterÓÐ79482Ìõ¼Ç¼£¬ÔÚmm_bookdetail±íµÄmmliid½¨Á¢ÁËË÷Òý£¬µ«ÊÇinnerjoinµÄ¿ªÏú»¹ÊǺܴó£¬ÎªÁËÓÅ»¯ÎÒÔÚ¿¼ÂDz»ÓÃÁ¬½Ó£¬µ«ÊDz»ÖªµÀÔõô¸Ã£¬»¹Íû¸÷λ´óÏÀ²»Ï§´Í½Ì£¬Ð»ÁË£¡

Ï£Íû´ó¼ÒÄܹ»°ïÖúËý¡£

ÏêϸÎÊÌâÃèÊö¼°ÒÉÎÊ£º

**LECTmmliid,max(M.PUdate)asPUdate,max(M.wsc_name)aswsc_name,count(*)ASbookTimesFROMmm_bookdetailDINNERJOINmm_bookmasterM

ONd.MCBKCode=M.MCBKCodegroupbymmliid


mm_bookdetail±íÓÐ849522Ìõ¼Ç¼£¬mm_bookmasterÓÐ79482Ìõ¼Ç¼£¬ÔÚmm_bookdetail±íµÄmmliid½¨Á¢ÁËË÷Òý£¬µ«ÊÇinnerjoinµÄ¿ªÏú»¹ÊǺܴó£¬ÎªÁËÓÅ»¯ÎÒÔÚ¿¼ÂDz»ÓÃÁ¬½Ó£¬µ«ÊDz»ÖªµÀÔõô¸Ã£¬»¹Íû¸÷λ´óÏÀ²»Ï§´Í½Ì£¬Ð»ÁË£¡

ÆÚ´ýÄúµÄ´ð°¸£¬²»ÖªµÀ˵ʲô,ËÍÄãÒ»¶äСºì»¨°É £¡
Ï£ÍûÒÔϵĻشð£¬Äܹ»°ïÖúÄã¡£

µÚ1¸ö»Ø´ð

Óû§Ãû£ºå´»úÊìÊÖ  

ÓõÈÖµÁ¬½Ó°É¡£

ÕâÖÖgroupbyµÄ²Ù×÷·´Õý¶¼ÊÇÐèҪȫ±í¶ÁÈ¡µÄ£¬Ë÷ÒýûÓ㬸ü»µµÄÇé¿öÊÇË÷Òýµ¼Ö²éѯ¸üÂý

select.mm_boÎÊ´ðokdetaild,mm_bookmasterm

whered.mcÀî±øbkcode=m.mcbkcode

Èç¹ûÄãÕâ¸ö²»ÊÇÐèҪƵ·±Ö´Ðе쬲¢ÇÒÊÇÔÚoracleÄÇʶ¿ÆÌÖÖУ¬ÄÇôÄã¿ÉÒÔÓò¢ÐÐÌáʾ

ÏçËä¼ÍÖ¾±¨Âíζ¸®ÌøºñÓïselect/*paralle(parallel_degree)*/.mm_ô¿×ÎóÆø»ÓÇó×¢·Å»°Ãºbookdetaild,mm_bookmasterm

whered.mcbkcode=m.mcbkcode

Èç¹ûÄãÕâ¸ö²éѯÊÇÔÚdb2£¬Äǽö×óÂð´øÇÖ³öÀíôӦ¸ÃÊǷdz£¿ìµÄ1ÃëÒÔÄÚ°É

µÚ2¸ö»Ø´ð

Óû§Ãû£ºÖÇÄÜ»úÆ÷2014  

¾¡Á¿Ê¹ÓÃleftjoin

µÚ3¸ö»Ø´ð

Óû§Ãû£ºlimielon  

ËäÈ»Ò**ι¤ÐëΧҵ´´ÊýÄã¸ømmlid½¨Á¢ÁËË÷Òý£¬µ«ÄãµÄsqlûд¿¹Êʱ๻¶¯Ö°¿Õ»¤Á÷·þ¶ûwhereÌõ¼þ£¬ÎÞ·¨Ê¹ÓÃÕâ¸öË÷Òý£»

1.ÄÜ·ñÔö¼ÓËõСνÒòµ×Ê®Á¸¾ù**·¶Î§µÄwhereÌõ¼þ£¬ÓÈÆäÊÇʹÓÃÁËË÷ÒýµÄwhereÌõ¼þ£»

2.¸øÁ½¸ö±íµÄMCBKCode×ֶμÓË÷Òý£»

3.count²»ÒªÓÃÐǺţ¬Ð´¸öÄÜÓÃÓÚͳ¶Ô¼¤Ã«ÎÄÇ¿Íâ¾ßÄļ临¶¯¼ÆÊýÁ¿µÄ×ֶΣ¬±ÈÈçid

µÚ4¸ö»Ø´ð

Óû§Ãû£º¼ª¶û¼ÑÃÀʸ  

²»ÒªÓÃinnerjoin£¬¾¡Á¿Ê¹ÓÃleftjoin£¬¿ÉÒÔ½ÚÊ¡ºÜ¶àʱ¼äºÍ¿Õ¼ä¡£

µÚ5¸ö»Ø´ð

Óû§Ãû£º°¦°¦°¦°¦°¦°¦0  

²»ÊÇÓиö**¼¯DateSet¶ÔÏó÷᣿