Mysql order by囂鞘議單晒
<貧匯准
和匯准>
壓蝶乂秤趨嶄?MySQL辛參聞喘匯倖沫哈栖諾怎ORDER BY徨鞘?遇音俶勣駆翌議電會。where訳周才order by聞喘屢揖議沫哈?旺拝order by議乏會才沫哈乏會屢揖?旺拝order by議忖粁脅頁幅會賜宀脅頁週會。
箭泌?和双sql辛參聞喘沫哈。
SELECT * FROM t1 ORDER BY key_part1,key_part2,... ;
SELECT * FROM t1 WHERE key_part1=1 ORDER BY key_part1 DESC, key_part2 DESC;
SELECT * FROM t1 ORDER BY key_part1 DESC, key_part2 DESC;
徽頁參和秤趨音聞喘沫哈。
1) SELECT * FROM t1 ORDER BY key_part1 DESC, key_part2 ASC?
--order by議忖粁詞栽ASC才DESC
2) SELECT * FROM t1 WHERE key2=constant ORDER BY key1?
--喘噐臥儂佩議購囚忖嚥ORDER BY嶄侭聞喘議音屢揖
3) SELECT * FROM t1 ORDER BY key1, key2?
--斤音揖議購囚忖聞喘ORDER BY
箭泌?和双sql辛參聞喘沫哈。
SELECT * FROM t1 ORDER BY key_part1,key_part2,... ;
SELECT * FROM t1 WHERE key_part1=1 ORDER BY key_part1 DESC, key_part2 DESC;
SELECT * FROM t1 ORDER BY key_part1 DESC, key_part2 DESC;
徽頁參和秤趨音聞喘沫哈。
1) SELECT * FROM t1 ORDER BY key_part1 DESC, key_part2 ASC?
--order by議忖粁詞栽ASC才DESC
2) SELECT * FROM t1 WHERE key2=constant ORDER BY key1?
--喘噐臥儂佩議購囚忖嚥ORDER BY嶄侭聞喘議音屢揖
3) SELECT * FROM t1 ORDER BY key1, key2?
--斤音揖議購囚忖聞喘ORDER BY
<貧匯准
和匯准>