Äܲ»ÄÜÖ»ÓÃÒ»Ìõsql¹ýÂËÈçÏÂÄÚÈÝ£¿
Ò»¸ö×Ö¶ÎÖÐÓÐÈçϼǼ
ԼǼ a,a,b,a,c,a,b,c,b,c,a,(¼Ç¼ÖÐÓн϶àͬÑù¼Ç¼£©
½á¹û a,b,c(Â˵ôͬÑùµÄ£©
SQL code:
select distinct Ò»¸ö×Ö¶Î from ԼǼ
µ±ÄúµÄÎÊÌâµÃµ½½â´ðºóÇ뼰ʱ½áÌù.
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html
ԼǼ a,a,b,a,c,a,b,c,b,c,a,(¼Ç¼ÖÐÓн϶àͬÑù¼Ç¼£©
ÊÇÒ»Ìõ¼Ç¼£¿
13.2.7. SELECTÓï·¨
http://dev.mysql.com/doc/refman/5.1/zh/sql-syntax.html#select
ÔÚSELECT¹Ø¼ü´ÊµÄºóÃæ£¬Äú¿ÉÒÔʹÓÃÐí¶àÑ¡Ïî¡£ÕâЩѡÏî¿ÉÒÔÓ°ÏìÓï¾äµÄÔËÐС£
ALL, DISTINCTºÍDISTINCTROWÑ¡ÏîÖ¸¶¨ÊÇ·ñÖØ¸´ÐÐÓ¦±»·µ»Ø¡£Èç¹ûÕâЩѡÏîûÓб»¸ø¶¨£¬ÔòĬÈÏֵΪALL£¨ËùÓÐµÄÆ¥ÅäÐб»·µ»Ø£©¡£DISTINCTºÍDISTINCTROWÊÇͬÒå´Ê£¬ÓÃÓÚÖ¸¶¨½á¹û¼¯ºÏÖеÄÖØ¸´ÐÐÓ¦±»É¾³ý¡£
ԼǼ a,a,b,a,c,a,b,c,b,c,a,(¼Ç¼ÖÐÓн϶àͬÑù¼Ç¼£©
½á¹û a,b,c(Â˵ôͬÑùµÄ£©
-------------------------
"a,a,b,a,c,a,b,c,b,c,a,"Õâ¸öÊÇÒ»Ìõ¼Ç¼»¹ÊǶàÌõ¼Ç¼£¿
Èç¹ûÊÇÒ»Ìõ¼Ç¼µÄ»°£¬ÄǵÃ×Ô¼ºÐ´¸öº¯ÊýÀ´½øÐÐÅжϴ¦ÀíÁË£»
Èç¹ûÊǶàÌõ¼Ç¼µÄ»°£¬ÔòÕâÑù£º
SQL code:
select group_concat(distinct field_name) from tb_name;
һ¥µÄÎÒÊÔÊÔ
¶þÂ¥£º
ÏÖÔÚÓÐÁ½¸öÒì¹¹µÄsql serverÊý¾Ý¿â,ÎÒÏ뽫µÚÒ»¸ö±íÖеÄÊý¾Ýµ¼Èëµ½µÚ¶þ¸ö±íÖÐ,×Ô¼ºÖ¸¶¨µ¼ÈëÊý¾ÝµÄ×Ö¶Î,ÈçºÎµ¼ÈëÊý¾ÝÄØ,´ó¼ÒÌÖÂÛÒ»ÏÂ?
dts¹¤¾ß
µ¼Èëµ¼³ö¹¤¾ß.
DD
¹þ¹þ£¬¹À¼ÆÕâλÊǵØQIOU¶¼Êܲ»Á˵Ä
Ö±½ÓÐ ......
´ó¼Ò°ïæ¿´¿´Õâ2¸ösqlÓï¾äÄĸö²éѯµÄËٶȸü¿ìµã¡£Ð»Ð»°ïæ¡£±È½Ï׿±¡£ÔÚ×öÐÔÄܲâÊÔ¡£
select * from
±íA LEFT OUTER JOIN ±íB ON (±íA.id || ' ' =±íB.id) ,±íC , ±íD, ±íE
WhereÆäËûÌõ¼þ
select * ......