{"id":317488,"date":"2021-02-04T19:47:29","date_gmt":"2021-02-04T11:47:29","guid":{"rendered":"http:\/\/4563.org\/?p=317488"},"modified":"2021-02-04T19:47:29","modified_gmt":"2021-02-04T11:47:29","slug":"sql-order-by-%e4%bb%a5%e5%90%8e-%e6%80%8e%e4%b9%88%e5%81%9a%e6%8e%90%e5%a4%b4%e5%8e%bb%e5%b0%be","status":"publish","type":"post","link":"http:\/\/4563.org\/?p=317488","title":{"rendered":"SQL order by \u4ee5\u540e, \u600e\u4e48\u505a\u6390\u5934\u53bb\u5c3e"},"content":{"rendered":"<div>\n<div>\n<div>\n<h1>                  SQL order by \u4ee5\u540e, \u600e\u4e48\u505a\u6390\u5934\u53bb\u5c3e               <\/h1>\n<p> <\/p>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : DinoStray <\/span>  <span><i><\/i> 4<\/span> <\/div>\n<div> <\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<div isfirst=\"1\"> <\/p>\n<p>\u60f3\u628a\u7b2c\u4e00\u4e2a\u548c\u6700\u540e\u4e00\u4e2a\u5143\u7d20\u53bb\u6389, \u56e0\u4e3a\u53ea\u662f\u5355\u7eaf\u7528 sql \u5904\u7406\u6570\u636e, \u6ca1\u6709\u4e0a\u5c42\u8bed\u8a00\u5c01\u88c5\u8c03\u7528, \u4e0d\u77e5\u9053\u600e\u4e48\u641e\u4e86<\/p>\n<\/p><\/div>\n<div> <b>\u5927\u4f6c\u6709\u8a71\u8aaa<\/b> (<span>9<\/span>)        <\/div>\n<div> <\/div>\n<\/p><\/div>\n<\/p><\/div>\n<ul>\n<li data-pid=\"5070820\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : mara1 <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u7528\u53d8\u91cf\u5b58\u4e00\u4e0b \u641c\u51fa\u6765\u4e86\u591a\u5c11\u6761, \u7136\u540e select limit offset \u884c\u4e0d?                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"5070821\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u4e3b<\/span> <span>\u8cc7\u6df1\u5927\u4f6c : DinoStray <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @mara1 \u8fd9\u6837\u53ea\u80fd\u53bb\u6389\u6700\u540e\u4e00\u6761\u8bb0\u5f55\u5427                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"5070822\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : JJstyle <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             select from(select from (select from&#8230;)))                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"5070823\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : levelworm <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u4e5f\u53ef\u4ee5\u7a97\u53e3\u51fd\u6570\u5199\u4e24\u5217\u884c\u6570\uff0c\u4e00\u5217\u6b63\u5411\u4e00\u5217\u53cd\u5411\uff0c\u6700\u540e\u53bb\u6389\u4e24\u5217\u4e2d\u7684 1                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"5070824\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : notejava <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u4e0d\u8003\u8651\u6548\u7387\u7684\u8bdd\uff1a<br \/>select * from table where id not in ((select min(id) from table), (select max(id) from table))                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"5070825\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : Dvel <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             &#8230; limit 1 offset ((select count(*) from &#8230;) &#8211; 2)                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"5070826\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : jazzychai <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @Dvel \u53cd\u4e86 \u5927\u5144\u5f1f                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"5070827\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : Dvel <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @jazzychai #7 \u54c8\u54c8\u5fd8\u4e86<br \/>&#8230; limit 1, ((select count(*) from &#8230;) &#8211; 2)                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"5070828\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u4e3b<\/span> <span>\u8cc7\u6df1\u5927\u4f6c : DinoStray <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @notejava \u7231\u6b7b\u4f60\u4e86                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li>\n","protected":false},"excerpt":{"rendered":"<p>SQL order by \u4ee5\u540e, &hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[],"tags":[],"_links":{"self":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/317488"}],"collection":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=317488"}],"version-history":[{"count":0,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/317488\/revisions"}],"wp:attachment":[{"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=317488"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=317488"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=317488"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}