sqlÅÅÐò

ÎÒÏë²éѯ±íÖÐËùÓÐÁУ¬µ«ÊÇÎÒÏëÈÃidΪ1µÄÏÈÁгöÀ´£¬È»ºóÊÇÆäËüÁУ¬Õ¦°ìÄó£¿


SQL code:
select * from table where 1=1 order by id=1 £¿£¿£¿£¿£¿

---

select * from table order by id

---

ÒýÓÃ

select * from table order by id

»¹ÓеÄidΪ2£¬3£¬0£¬null Á¨£¡~

---

select * from table where id=1 union select * from table where id <>1

---

¿´À´ÎÊÌâËƺõÓеãÄѶȰ¡£¡

°¥£¡~

С°×Ò²²»Ëµ»°ÁËÄØ£¡

---

ÄÇÊÔÊÔÕâôд£º
select * from table order by case when id=1 then 0  else 1 end

---

ÒýÓÃ

ÄÇÊÔÊÔÕâôд£º
select * from table order by case when id=1 then 0  else 1 end

2¸ö×Ö£º
Åå·þ£¡