ÄÜʵÏÖÂð£¿
ÎÒÓÐÒ»¸öÊý×飺 $subscibe = array( "Á½ÐÔ²£Á§", "²ÊɫЦ»°...
²Ý¸ù³ÌÐòÔ±Ö®¼Ò£¬·îÏ׸øPHP·ÛË¿µÄ·¢Ð¹Ú££¬·¢¹ã¸æµÄÒ»ÂÉip break´¦Àí¡£
×÷Õß pooer ·¢²¼ÓÚ 2003-09-01 ·ÖÀࣺphp»ù´¡±à³Ì
Êý¾Ý±í´æÓкܶàemailµØÖ·£¬ÆäÖÐÓкܶàÖØ¸´µÄ£¬
ÎÒÒª°ÑÖØ¸´µÄemailµÄµØÖ·ÕÒ³öÀ´£¬ÇëÎÊÔõô²éѯ°¡£¿
sleect email from table group by email
²»Ðа¡£¿
¹äÂÛ̳½»Á÷£ºÔõÑù²éѯÊý¾Ý¿âÀïÏàͬµÄÊý¾Ý°¡£¿
mysqlÊý¾ÝÔõÑù¿ÉÒÔתΪsqlserverÊý¾Ý£¿
Ò»¸öÍøÕ¾ºÍÆäÂÛ̳¹²ÓÃÒ»¸öÓû§Êý¾Ý±íµÄÎÊÌâ¡£
ÔõôûÈ˰ïæ°¡£¿
ÄѵÀÕâ¸öÎÊÌâºÜÉî°ÂÂð£¿
ÎÒûÓÐÓ¡ÏóÁË
¶¬¶¬»Ø´ð¹ý
»òÕßµ½¶¬¶¬µÄ×ÊÁÏ¿âÕÒÒ»ÏÂ
²»ÊÇ£¬ºÃÏ󹨼ü×ÖÊÇunique
select email from table group by email
Õâ¸ö¶ÔµÄ°¡
QUOTE: ×î³õÓÉ qsy_627 ·¢²¼
[B]select email from table group by email
Õâ¸ö¶ÔµÄ°¡ [/B]
Õâ¸ö²»Ðа¡£¿
group by email Êǰ´×éÀ´²éѯµÄ£¡
¼ÙÈçÊý¾Ý±íÀïÓÐÁ½¸ö id £¨123¡¢34£©µÄ email µØÖ·¶¼ÊÇÒ»ÑùµÄ£¬ÎÒÔõÑù²ÅÄܰÑÕâÁ½¸öÓÐÏàͬµÄ email µØÖ·µÄ id ²éÕÒ³öÀ´°¡£¿
ΪʲôҪgroup by°¡¡£
select DISTINCT email from tabel;ÕâÑù¿É²»¿ÉÒÔ°¡¡£
select a.id from a a, a b where a.email=b.email and
a.id!=b.id;Ô´´,ÊÔ¹ý,ºÃÓÃ!
¼ÙÈçÓÐÁ½¸öÓû§ËûÃǵÄip¶¼ÊǶ¯Ì¬µÄ£¬ÒªÓÃʲô×÷ΪÒÀ¾ÝÀ´ÅжÏÊÇ·ñ...
ÎÒÏëͨ¹ý¼ÆËã×Ö½ÚÊýÀ´²éѯÊý¾Ý ÓÃphpÔõô¿ØÖÆÐ´ÈëÊý¾ÝµÄ×Ö½ÚÊý...
7 Ìõ»Ø¸´
»Ø¸´