MS SQLÊÓͼµÄ×÷ÓÃ
µÚÒ»µã£º
ʹÓÃÊÓͼ£¬¿ÉÒÔ¶¨ÖÆÓû§Êý¾Ý£¬¾Û½¹Ìض¨µÄÊý¾Ý¡£
½âÊÍ£º
ÔÚʵ¼Ê¹ý³ÌÖУ¬¹«Ë¾Óв»Í¬½ÇÉ«µÄ¹¤×÷ÈËÔ±£¬ÎÒÃÇÒÔÏúÊÛ¹«Ë¾ÎªÀýµÄ»°£¬
²É¹ºÈËÔ±£¬¿ÉÒÔÐèҪһЩÓëÆäÓйصÄÊý¾Ý£¬¶øÓëËûÎ޹صÄÊý¾Ý£¬¶ÔËûû
ÓÐÈκÎÒâÒ壬ÎÒÃÇ¿ÉÒÔ¸ù¾ÝÕâһʵ¼ÊÇé¿ö£¬×¨ÃÅΪ²É¹ºÈËÔ±´´½¨Ò»¸öÊÓ
ͼ£¬ÒÔºóËûÔÚ²éѯÊý¾Ýʱ£¬Ö»Ðèselect * from view_caigou ¾Í¿ÉÒÔÀ²¡£
µÚ¶þµã£ºÊ¹ÓÃÊÓͼ£¬¿ÉÒÔ¼ò»¯Êý¾Ý²Ù×÷¡£
½âÊÍ£ºÎÒÃÇÔÚʹÓòéѯʱ£¬ÔںܶàʱºòÎÒÃÇҪʹÓþۺϺ¯Êý£¬Í¬Ê±»¹Òª
ÏÔʾÆäËü×ֶεÄÐÅÏ¢£¬¿ÉÄÜ»¹»áÐèÒª¹ØÁªµ½ÆäËü±í£¬ÕâʱдµÄÓï¾ä¿ÉÄÜ
»áºÜ³¤£¬Èç¹ûÕâ¸ö¶¯×÷Ƶ·±·¢ÉúµÄ»°£¬ÎÒÃÇ¿ÉÒÔ´´½¨ÊÓͼ£¬ÕâÒÔºó£¬ÎÒ
ÃÇÖ»ÐèÒªselect * from view1¾Í¿ÉÒÔÀ²¡«£¬ÊDz»ÊǺܷ½±ãѽ¡«
µÚÈýµã£ºÊ¹ÓÃÊÓͼ£¬»ù±íÖеÄÊý¾Ý¾ÍÓÐÁËÒ»¶¨µÄ°²È«ÐÔ
ÒòΪÊÓͼÊÇÐéÄâµÄ£¬ÎïÀíÉÏÊDz»´æÔڵģ¬Ö»ÊÇ´æ´¢ÁËÊý¾ÝµÄ¼¯ºÏ£¬ÎÒÃÇ¿ÉÒÔ
½«»ù±íÖÐÖØÒªµÄ×Ö¶ÎÐÅÏ¢£¬¿ÉÒÔ²»Í¨¹ýÊÓͼ¸øÓû§£¬ÊÓͼÊǶ¯Ì¬µÄÊý¾ÝµÄ¼¯
ºÏ£¬Êý¾ÝÊÇËæ×Å»ù±íµÄ¸üжø¸üС£Í¬Ê±£¬Óû§¶ÔÊÓͼ£¬²»¿ÉÒÔËæÒâµÄ¸ü¸Ä
ºÍɾ³ý£¬¿ÉÒÔ±£Ö¤Êý¾ÝµÄ°²È«ÐÔ¡£
µÚËĵ㣺¿ÉÒԺϲ¢·ÖÀëµÄÊý¾Ý£¬´´½¨·ÖÇøÊÓͼ
Ëæ×ÅÉç»áµÄ·¢Õ¹£¬¹«Ë¾µÄÒµÎñÁ¿µÄ²»¶ÏµÄÀ©´ó£¬Ò»¸ö´ó¹«Ë¾£¬ÏÂÊô¶¼ÉèÓкÜ
¶àµÄ·Ö¹«Ë¾£¬ÎªÁ˹ÜÀí·½±ã£¬ÎÒÃÇÐèҪͳһ±íµÄ½á¹¹£¬¶¨Æڲ鿴¸÷¹«Ë¾ÒµÎñ
Çé¿ö£¬¶ø·Ö±ð¿´¸÷¸ö¹«Ë¾µÄÊý¾ÝºÜ²»·½±ã£¬Ã»ÓкܺõĿɱÈÐÔ£¬Èç¹û½«ÕâЩ
Êý¾ÝºÏ²¢ÎªÒ»¸ö±í¸ñÀ¾Í·½±ã¶àÀ²£¬ÕâʱÎÒÃǾͿÉÒÔʹÓÃunion¹Ø¼ü×Ö£¬
½«¸÷·Ö¹«Ë¾µÄÊý¾ÝºÏ²¢ÎªÒ»¸öÊÓͼ¡£
ÒÔÉÏ£¬¾ÍÊÇÎÒÈÏΪÊÓͼµÄ×÷Óã¬Êµ¼ÊÉϺܶ๫˾¶¼Ê¹ÓÃÊÓͼÀ´²éѯÊý¾ÝµÄ¡£
Ïà¹ØÎĵµ£º
ϵͳ»·¾³£ºWindows 7
Èí¼þ»·¾³£ºVisual C++ 2008 SP1 +SQL Server 2005
±¾´ÎÄ¿µÄ£º±àдһ¸öº½¿Õ¹ÜÀíϵͳ
ÕâÊÇÊý¾Ý¿â¿Î³ÌÉè¼ÆµÄ³É¹û£¬ËäÈ»³É¼¨²»¼Ñ£¬µ«ÊÇ×÷ΪÎÒÓÃVC++ ÒÔÀ´±àдµÄ×î´ó³ÌÐò»¹ÊÇ´«µ½ÍøÉÏ£¬ÒÔ¹©²Î¿¼¡£ÓÃVC++ ×öÊý¾Ý¿âÉè¼Æ²¢²»ÈÝÒ×£¬µ«Ò²²»ÊDz»¿ÉÄÜ¡£ÒÔÏÂÊÇÎҵijÌÐò½çÃ棬ºóÃæ ......
·½·¨Ò»£º
select distinct name from tablename
·½·¨¶þ£º
select min(fid),name,sex from tablename group by name
×ܼƣº
select distinct name from tablename ´ò¿ªÖظ´¼Ç¼µÄµ¥¸ö×Ö¶Î
select * from tablename where fid in(Select min(fid) from tablename group by name)´ò¿ªÖظ´¼Ç¼µÄËùÓÐ×Ö¶ÎÖµ
select ......
SQLÓïÑÔ¿ìËÙÈëÃÅ
ä½ Ïª ɳ
Àî璟
ÊÖ¾íÕæÖéÉÏÓñ¹³,ÒÀÇ°´ººÞËøÖØÂ¥, ·çÀïÂ仨ËÊÇÖ÷, ˼ÓÆÓÆ
ÇàÄñ²»´«ÔÆÍâÐÅ,¶¡Ïã¿Õ½áÓêÖгî, »ØÊ×Â̲¨Èý³þĺ, ½ÓÌìÁ÷
SQLÓïÑÔ¿ìËÙÈëÃÅ
SQLÊÇÓ¢ÎÄStructured Query LanguageµÄËõд£¬Òâ˼Ϊ½á¹¹»¯²éѯÓïÑÔ¡£SQLÓïÑÔµÄÖ÷Òª¹¦ÄܾÍÊÇͬ¸÷ÖÖÊý¾Ý¿â½¨Á¢ÁªÏµ£¬½øÐйµÍ¨¡£°´ÕÕA ......
ͨ¹ýÁ¬½ÓÔËËã·û¿ÉÒÔʵÏÖ¶à¸ö±í²éѯ¡£Á¬½ÓÊǹØϵÊý¾Ý¿âÄ£Ð͵ÄÖ÷ÒªÌص㣬ҲÊÇËüÇø±ðÓÚÆäËüÀàÐÍ
Êý¾Ý¿â¹ÜÀíϵͳµÄÒ»¸ö±êÖ¾¡£
ÔÚ¹ØϵÊý¾Ý¿â¹ÜÀíϵͳÖУ¬±í½¨Á¢Ê±¸÷Êý¾ÝÖ®¼äµÄ¹Øϵ²»±ØÈ·¶¨£¬³£°ÑÒ»¸öʵÌåµÄËùÓÐÐÅÏ¢´æ·ÅÔÚ
Ò»¸ö±íÖС£µ±¼ìË÷Êý¾Ýʱ£¬Í¨¹ýÁ¬½Ó²Ù×÷²éѯ³ö´æ·ÅÔÚ¶à¸ö±íÖеIJ»Í¬ÊµÌåµÄÐÅÏ¢¡£Á¬½Ó²Ù×÷¸øÓû ......
¹«Ë¾Óиö±¨±íϵͳÏìÓ¦ËٶȲ»ÊǺÜÀíÏ룬µ÷Óŵ÷Á˺ü¸´Î£¬ÓеãЧ¹û£¬µ«²»ÊǺÜÈÃÈËÂúÒâ¡£×î½üÓÖ¿ªÊ¼µ÷ÓÅ£¬ÊÔÁËÊÔsql server 2008µÄ·ÖÇø±í¹¦ÄÜ£¬¿´¿´ÊDz»ÊÇ·ÖÇøÖ®ºóËٶȿÉÒÔ¿ìÒ»µã¡£
ÓÃÁËÒ»¸ö°ÙÍò¼¶Êý¾ÝµÄ»ã×ܱíÀ´×ö·ÖÇø£¬·ÖÇøµÄÏë·¨ÊÇ°´ÔÂÀ´·ÖÇø£¬Ò»¸ö·ÖÇø´æ´¢Ò»¸öÔµÄÊý¾Ý£¬Ò»¸ö·ÖÇøµ ......