sql sql sql Óï¾ä~~~

²éѯǰ10¸ö trait_value²»Öظ´µÄÐÐ

select distinct trait_value from articles limit 0,10
ÉÏÃæû´í£¬µ«ÊÇ¿´ÏÂÃæµÄΪʲô´íÁË
select distinct trait_value,id ,parent_id ,child_id,dg_id from articles limit 0,10
ÏÖÔÚ¾ÍÊÇÖظ´µÄÁË

¸ÃÔõô¸Ä£¿£¿

---

select * from (select distinct trait_value from articles) t limit 10;
ÊÇÑ¡³öÕâЩ×ֶζ¼²»Öظ´µÄ¡£


˵Ã÷Ò»ÏÂÄãÐèÒªµÄ½á¹ûÊÇʲô£¿

---

µÚÒ»ÌõÊÇÑ¡³ötrait_value Õâ¸ö×ֶβ»Öظ´µÄÇ°Ê®ÐмǼ
µÚ¶þÌõÊÇÑ¡³ötrait_value,id ,parent_id ,child_id,dg_id Ëĸö×ֶζ¼²»Öظ´µÄÇ°Ê®ÐмǼ

---

ÒýÓÃ

select distinct trait_value,id ,parent_id ,child_id,dg_id from articles limit 0,10
ÏÖÔÚ¾ÍÊÇÖظ´µÄÁË

Ó¦¸Ã²»»áÓÐÕ⼸¸ö×ֶζ¼ÏàͬµÄ¼Ç¼³öÏÖ°¡¡£»òÕßÄã¿ÉÒÔÌù³öÕâЩ¼Ç¼£¬²¢Ö¸³öÖظ´µÄ¼Ç¼¡£

---

Ŷ£¬Âò¸ÁµÄ£¡ÎÒÇ°ÃæÓмÓÁ˸ödg_id
ÎÒµÄsqlÊÇ£ºselect distinct trait_value , id , parent_id , child_id ,dg_id from fenlei
where (dg_id = 1 and parent_id = 0  and articles is not null) or
(dg_id = 2 and parent_id = 0  and articles is not null) limit 1,10

---

ÏÈллÁË£¬ÎÒÕâÁ½Ìì¸ÏÏîÄ¿£¬ÒòΪÎÒÒªÇë½Ì»Ø¼Ò½á»éÁË
Á¬¸ö¾õ¶¼Ã»Ë¯ºÃ£¬àË£¡ÄÔ´ü¶¼²»¹»ÓÃÁË£¬»¹²»ÈçºÃºÃ˯¾õºÃºÃÉÏ°àÄØ~~~~

---

ÒýÓÃ

ÏÈллÁË£¬ÎÒÕâÁ½Ìì¸ÏÏîÄ¿£¬ÒòΪÎÒÒªÇë½Ì»Ø¼Ò½á»éÁË

¹§Ï²

---

ÒýÓÃ

ÒýÓÃÏÈллÁË£¬ÎÒÕâÁ½Ìì¸ÏÏîÄ¿£¬ÒòΪÎÒÒªÇë½Ì»Ø¼Ò½á»éÁ