sqliteÊý¾Ý¿â²éѯ±í¿¿Ç°

¸ÕÈëÃÅ ÏëʵÏÖÐÂÎűíÐÂÎÅÖö¥µÄ¹¦ÄÜ

select * from web_news  order by id desc limit 0,6

web_news ±íÀïÓÐTOPÁÐ ÔõÑùÈÃTOPÁмǼΪ1µÄΪÖÃÇ°  ¸÷λ´ó´óÃÇ°ï°ïæ ·Ö²»¶à Çë°üº­£¡£¡

---

order by top²»ÐÐÂð£¿

idºÍtopÄǸöÓÅÏÈ£¿

---

SQL code:
select * from web_news order by top!=1 ,id desc limit 0,6;

---

ÄãµÄÒâ˼ÊDz»ÊÇtop=1µÄÊÇÖö¥µÄÄØ£¿
SELECT * from  web_news ORDER BY `topid` DESC LIMIT 0 , 6

---

²¹³äһϣ¡

ÄãµÄÒâ˼ÊDz»ÊÇtop=1µÄÊÇÖö¥top=0µÄ²»Öö¥µÄÄØ£¿
SELECT * from  web_news ORDER BY 'top' DESC LIMIT 0 , 6

---

ÒýÓÃ

SQL codeselect*from web_newsorderbytop!=1 ,iddesc limit0,6;

THANK YOU  ½â¾öÁË!