½ðɳ¼¯ÍŹÙÍø:²ÆÎñÈí¼þÖ®±¾±íËûҳȡÊýº¯Êý
2018-09-03 10:59 À´Ô´£º½ðɳ¼¯ÍŹÙÍø
ºÜ¶à±¨±íÊý¾ÝÊÇ´ÓÒÔÇ°µÄÀúÊ·¼Ç¼ÖÐÈ¡µÃµÄ£¬Èç±¾±íÆäËû±íÒ³¡£µ±È»£¬ÕâÀàÊý¾Ý¿ÉÒÔͨ¹ý²éѯÀúÊ·×ÊÁ϶øÈ¡µÃ£¬µ«ÊÇ£¬²éѯ¼È²»·½±ã£¬ÓÖ»áÓÉÓڳд´íÎó¶øÒýÆðÊý¾ÝµÄʧÕæ¡£¶øÈç¹ûÔÚ¼ÆË㹫ʽÖнøÐÐÈ¡ÊýÉ趨£¬¼È¼õÉÙ¹¤×÷Á¿£¬ÓÖ½ÚԼʱ¼ä£¬Í¬Ê±Êý¾ÝµÄ׼ȷÐÔÒ²µÃµ½Á˱£ÕÏ¡£Õâ¾ÍÐèÒªÓõ½±íÒ³Óë±íÒ³¼äµÄ¼ÆË㹫ʽ¡£¡¡¡¡£¨1£© È¡È·¶¨Ò³ºÅ±íÒ³µÄÊý¾Ý¡£µ±ËùÈ¡Êý¾ÝËùÔڵıíÒ³Ò³ºÅÒÑ֪ʱ£¬ÓÃÒÔϸñʽ¿ÉÒÔ·½±ãµØÈ¡µÃ±¾±íËûÒ³µÄÊý¾Ý£º¡¡¡¡<Ä¿±êÇøÓò>£½<Êý¾ÝÔ´ÇøÓò> £À<Ò³ºÅ>¡¡¡¡ÀýÈ磺ÏÂÃæµ¥Ôª¹«Ê½Áî¸÷Ò³B2µ¥Ôª¾ùÈ¡µ±Ç°±íµÚÒ»Ò³C5µ¥ÔªµÄÖµ¡£Æä±íʾÈçÏ£º¡¡¡¡B2= C5£À1¡¡¡¡£¨2£©°´Ò»¶¨¹Ø¼ü×ÖÈ¡Êý¡£SELECT£¨£©º¯Êý³£ÓÃÓÚ´Ó±¾±íËûҳȡÊý¼ÆËã¡£¡¡¡¡ÀýÈ磺ÔÚ“ËðÒæ±í” ÖУ¬ÀÛ¼ÆÊý = ±¾ÔÂÊý+ͬÄêÉÏÔÂÀÛ¼ÆÊý£¬±íʾΪ£º¡¡¡¡D£½C+SELECT (D£¬Äê£À=ÄêandÔ£À=ÔÂ+1)