¡¡¡¡
SELECT DISTINCT Óï¾ä
ÔÚ±íÖУ¬¿ÉÄÜ»á°üº¬Öظ´Öµ¡£Õâ²¢²»³ÉÎÊÌ⣬²»¹ý£¬ÓÐʱÄúÒ²ÐíÏ£Íû½ö½öÁгö²»Í¬£¨distinct£©µÄÖµ¡£
¹Ø¼ü´Ê DISTINCT ÓÃÓÚ·µ»ØÎ¨Ò»²»Í¬µÄÖµ¡£
Óï·¨£º£¨Èç¹ûÊǶàÁÐÈ¥ÖØ£¬¿Éд¶à¸öÁÐÃû³Æ£¬²¢ÔÚÁÐÃû³ÆÖ®¼äʹÓà "," ¸ô¿ª£©
SELECT DISTINCT ÁÐÃû³Æ FROM ±íÃû³Æ where Ìõ¼þ
ÉÏÃæÕâ¸ö·½·¨ÊÇ×î׼ȷµÄ
ÍøÉÏËùÊôµÄÕâÖÖ·½·¨ÊDz»×¼È·µÄ
select * from ±íÃû where Ö÷¼ü in(select max(Ö÷¼ü) from ±íÃû group by ÒªÈ¥ÖØµÄ×Ö¶Î )
ÕâÖÖ·½·¨ÊDz»×¼È·