µ±ÄúµÄÎÊÌâµÃµ½½â´ðºóÇ뼰ʱ½áÌù. http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html Ìù¼Ç¼¼°ÒªÇó½á¹û³öÀ´¿´¿´ °ÑÖظ´µÄ¹ýÂ˵ô:»¹ÒªÓÐÖظ´µÄ¼Ç¼£¿ try: select a.* from tt a inner join (select isbn from tt group by isbn having count(*)=1) b on a.isbn=b.isbn [color=#FF0000][/color] id ÊéÃû ISBN Ŀ¼ ¼ò½é 1 a null ÂÔ ÂÔ 2 b null ÂÔ ÂÔ 3 c 1 ÂÔ ÂÔ 4 c 1 ÂÔ ÂÔ ²»ÏàµÄÊéĿ¼£¬¼ò½é²»Í¬£¬¶øÇÒÏàͬµÄÊéÆäĿ¼ºÍ¼ò½éÒ²²»Í¬£¬µ«ÏàͬµÄÊéÖ»ÐèÏÔʾһÌõ¾Í¿ÉÒÔ£¬²»ÓÃÈ«ÏÔʾ£¬ÈçºÎдSQL£¬Ð»Ð»¡£
SQL code: select ÊéÃû,ISBN,first(Ŀ¼),first(¼ò½é) from tablename group by ÊéÃû,ISBN
ÓòéѯÓï¾ä select * from tab where fil like 'CK090902'ÄܲéÕÒ³öÒ»Ìõ¼Ç¼²¢ÏÔʾ³öÀ´ ¸ÄΪ select * from tab where fil = 'CK090902' ¾Í²»ÄܲéÕÒµ½£¬Ò²ÏÔʾ²»³öÀ´ ......