order by 你的名字 2022-12-29 09:36 111阅读 0赞 ## 原始的表 (用在例子中的): ## Orders 表: <table style="margin:10px 0px 0px; padding:0px; border:1px solid rgb(170,170,170); border-collapse:collapse; width:709px"> <tbody style="margin:0px; padding:0px; border:0px"> <tr style="margin:0px; padding:0px; border:0px"> <th style="margin:0px; padding:5px 15px 5px 5px; border:1px solid rgb(170,170,170); vertical-align:baseline; background-color:rgb(213,213,213)"> Company</th> <th style="margin:0px; padding:5px 15px 5px 5px; border:1px solid rgb(170,170,170); vertical-align:baseline; background-color:rgb(213,213,213)"> OrderNumber</th> </tr> <tr style="margin:0px; padding:0px; border:0px"> <td style="margin:0px; padding:5px 15px 5px 5px; border:1px solid rgb(170,170,170); vertical-align:text-top; background-color:rgb(239,239,239)"> IBM</td> <td style="margin:0px; padding:5px 15px 5px 5px; border:1px solid rgb(170,170,170); vertical-align:text-top; background-color:rgb(239,239,239)"> 3532</td> </tr> <tr style="margin:0px; padding:0px; border:0px"> <td style="margin:0px; padding:5px 15px 5px 5px; border:1px solid rgb(170,170,170); vertical-align:text-top; background-color:rgb(239,239,239)"> W3School</td> <td style="margin:0px; padding:5px 15px 5px 5px; border:1px solid rgb(170,170,170); vertical-align:text-top; background-color:rgb(239,239,239)"> 2356</td> </tr> <tr style="margin:0px; padding:0px; border:0px"> <td style="margin:0px; padding:5px 15px 5px 5px; border:1px solid rgb(170,170,170); vertical-align:text-top; background-color:rgb(239,239,239)"> Apple</td> <td style="margin:0px; padding:5px 15px 5px 5px; border:1px solid rgb(170,170,170); vertical-align:text-top; background-color:rgb(239,239,239)"> 4698</td> </tr> <tr style="margin:0px; padding:0px; border:0px"> <td style="margin:0px; padding:5px 15px 5px 5px; border:1px solid rgb(170,170,170); vertical-align:text-top; background-color:rgb(239,239,239)"> W3School</td> <td style="margin:0px; padding:5px 15px 5px 5px; border:1px solid rgb(170,170,170); vertical-align:text-top; background-color:rgb(239,239,239)"> 6953</td> </tr> </tbody> </table> ## 实例 1 ## 以字母顺序显示公司名称: SELECT Company, OrderNumber FROM Orders ORDER BY Company ### 结果: ### <table style="margin:10px 0px 0px; padding:0px; border:1px solid rgb(170,170,170); border-collapse:collapse; width:709px"> <tbody style="margin:0px; padding:0px; border:0px"> <tr style="margin:0px; padding:0px; border:0px"> <th style="margin:0px; padding:5px 15px 5px 5px; border:1px solid rgb(170,170,170); vertical-align:baseline; background-color:rgb(213,213,213)"> Company</th> <th style="margin:0px; padding:5px 15px 5px 5px; border:1px solid rgb(170,170,170); vertical-align:baseline; background-color:rgb(213,213,213)"> OrderNumber</th> </tr> <tr style="margin:0px; padding:0px; border:0px"> <td style="margin:0px; padding:5px 15px 5px 5px; border:1px solid rgb(170,170,170); vertical-align:text-top; background-color:rgb(239,239,239)"> Apple</td> <td style="margin:0px; padding:5px 15px 5px 5px; border:1px solid rgb(170,170,170); vertical-align:text-top; background-color:rgb(239,239,239)"> 4698</td> </tr> <tr style="margin:0px; padding:0px; border:0px"> <td style="margin:0px; padding:5px 15px 5px 5px; border:1px solid rgb(170,170,170); vertical-align:text-top; background-color:rgb(239,239,239)"> IBM</td> <td style="margin:0px; padding:5px 15px 5px 5px; border:1px solid rgb(170,170,170); vertical-align:text-top; background-color:rgb(239,239,239)"> 3532</td> </tr> <tr style="margin:0px; padding:0px; border:0px"> <td style="margin:0px; padding:5px 15px 5px 5px; border:1px solid rgb(170,170,170); vertical-align:text-top; background-color:rgb(239,239,239)"> W3School</td> <td style="margin:0px; padding:5px 15px 5px 5px; border:1px solid rgb(170,170,170); vertical-align:text-top; background-color:rgb(239,239,239)"> 6953</td> </tr> <tr style="margin:0px; padding:0px; border:0px"> <td style="margin:0px; padding:5px 15px 5px 5px; border:1px solid rgb(170,170,170); vertical-align:text-top; background-color:rgb(239,239,239)"> W3School</td> <td style="margin:0px; padding:5px 15px 5px 5px; border:1px solid rgb(170,170,170); vertical-align:text-top; background-color:rgb(239,239,239)"> 2356</td> </tr> </tbody> </table> ## 实例 2 ## 以字母顺序显示公司名称(Company),并以数字顺序显示顺序号(OrderNumber): //一定要注意这个 SELECT Company, OrderNumber FROM Orders ORDER BY Company, OrderNumber 结果: <table style="margin:10px 0px 0px; padding:0px; border:1px solid rgb(170,170,170); border-collapse:collapse; width:709px"> <tbody style="margin:0px; padding:0px; border:0px"> <tr style="margin:0px; padding:0px; border:0px"> <th style="margin:0px; padding:5px 15px 5px 5px; border:1px solid rgb(170,170,170); vertical-align:baseline; background-color:rgb(213,213,213)"> Company</th> <th style="margin:0px; padding:5px 15px 5px 5px; border:1px solid rgb(170,170,170); vertical-align:baseline; background-color:rgb(213,213,213)"> OrderNumber</th> </tr> <tr style="margin:0px; padding:0px; border:0px"> <td style="margin:0px; padding:5px 15px 5px 5px; border:1px solid rgb(170,170,170); vertical-align:text-top; background-color:rgb(239,239,239)"> Apple</td> <td style="margin:0px; padding:5px 15px 5px 5px; border:1px solid rgb(170,170,170); vertical-align:text-top; background-color:rgb(239,239,239)"> 4698</td> </tr> <tr style="margin:0px; padding:0px; border:0px"> <td style="margin:0px; padding:5px 15px 5px 5px; border:1px solid rgb(170,170,170); vertical-align:text-top; background-color:rgb(239,239,239)"> IBM</td> <td style="margin:0px; padding:5px 15px 5px 5px; border:1px solid rgb(170,170,170); vertical-align:text-top; background-color:rgb(239,239,239)"> 3532</td> </tr> <tr style="margin:0px; padding:0px; border:0px"> <td style="margin:0px; padding:5px 15px 5px 5px; border:1px solid rgb(170,170,170); vertical-align:text-top; background-color:rgb(239,239,239)"> W3School</td> <td style="margin:0px; padding:5px 15px 5px 5px; border:1px solid rgb(170,170,170); vertical-align:text-top; background-color:rgb(239,239,239)"> 2356</td> </tr> <tr style="margin:0px; padding:0px; border:0px"> <td style="margin:0px; padding:5px 15px 5px 5px; border:1px solid rgb(170,170,170); vertical-align:text-top; background-color:rgb(239,239,239)"> W3School</td> <td style="margin:0px; padding:5px 15px 5px 5px; border:1px solid rgb(170,170,170); vertical-align:text-top; background-color:rgb(239,239,239)"> 6953</td> </tr> </tbody> </table> ## 实例 3 ## 以逆字母顺序显示公司名称: SELECT Company, OrderNumber FROM Orders ORDER BY Company DESC ### 结果: ### <table style="margin:10px 0px 0px; padding:0px; border:1px solid rgb(170,170,170); border-collapse:collapse; width:709px"> <tbody style="margin:0px; padding:0px; border:0px"> <tr style="margin:0px; padding:0px; border:0px"> <th style="margin:0px; padding:5px 15px 5px 5px; border:1px solid rgb(170,170,170); vertical-align:baseline; background-color:rgb(213,213,213)"> Company</th> <th style="margin:0px; padding:5px 15px 5px 5px; border:1px solid rgb(170,170,170); vertical-align:baseline; background-color:rgb(213,213,213)"> OrderNumber</th> </tr> <tr style="margin:0px; padding:0px; border:0px"> <td style="margin:0px; padding:5px 15px 5px 5px; border:1px solid rgb(170,170,170); vertical-align:text-top; background-color:rgb(239,239,239)"> W3School</td> <td style="margin:0px; padding:5px 15px 5px 5px; border:1px solid rgb(170,170,170); vertical-align:text-top; background-color:rgb(239,239,239)"> 6953</td> </tr> <tr style="margin:0px; padding:0px; border:0px"> <td style="margin:0px; padding:5px 15px 5px 5px; border:1px solid rgb(170,170,170); vertical-align:text-top; background-color:rgb(239,239,239)"> W3School</td> <td style="margin:0px; padding:5px 15px 5px 5px; border:1px solid rgb(170,170,170); vertical-align:text-top; background-color:rgb(239,239,239)"> 2356</td> </tr> <tr style="margin:0px; padding:0px; border:0px"> <td style="margin:0px; padding:5px 15px 5px 5px; border:1px solid rgb(170,170,170); vertical-align:text-top; background-color:rgb(239,239,239)"> IBM</td> <td style="margin:0px; padding:5px 15px 5px 5px; border:1px solid rgb(170,170,170); vertical-align:text-top; background-color:rgb(239,239,239)"> 3532</td> </tr> <tr style="margin:0px; padding:0px; border:0px"> <td style="margin:0px; padding:5px 15px 5px 5px; border:1px solid rgb(170,170,170); vertical-align:text-top; background-color:rgb(239,239,239)"> Apple</td> <td style="margin:0px; padding:5px 15px 5px 5px; border:1px solid rgb(170,170,170); vertical-align:text-top; background-color:rgb(239,239,239)"> 4698</td> </tr> </tbody> </table> ## 实例 4 ## 以逆字母顺序显示公司名称,并以数字顺序显示顺序号: SELECT Company, OrderNumber FROM Orders ORDER BY Company DESC, OrderNumber ASC ### 结果: ### <table style="margin:10px 0px 0px; padding:0px; border:1px solid rgb(170,170,170); border-collapse:collapse; width:709px"> <tbody style="margin:0px; padding:0px; border:0px"> <tr style="margin:0px; padding:0px; border:0px"> <th style="margin:0px; padding:5px 15px 5px 5px; border:1px solid rgb(170,170,170); vertical-align:baseline; background-color:rgb(213,213,213)"> Company</th> <th style="margin:0px; padding:5px 15px 5px 5px; border:1px solid rgb(170,170,170); vertical-align:baseline; background-color:rgb(213,213,213)"> OrderNumber</th> </tr> <tr style="margin:0px; padding:0px; border:0px"> <td style="margin:0px; padding:5px 15px 5px 5px; border:1px solid rgb(170,170,170); vertical-align:text-top; background-color:rgb(239,239,239)"> W3School</td> <td style="margin:0px; padding:5px 15px 5px 5px; border:1px solid rgb(170,170,170); vertical-align:text-top; background-color:rgb(239,239,239)"> 2356</td> </tr> <tr style="margin:0px; padding:0px; border:0px"> <td style="margin:0px; padding:5px 15px 5px 5px; border:1px solid rgb(170,170,170); vertical-align:text-top; background-color:rgb(239,239,239)"> W3School</td> <td style="margin:0px; padding:5px 15px 5px 5px; border:1px solid rgb(170,170,170); vertical-align:text-top; background-color:rgb(239,239,239)"> 6953</td> </tr> <tr style="margin:0px; padding:0px; border:0px"> <td style="margin:0px; padding:5px 15px 5px 5px; border:1px solid rgb(170,170,170); vertical-align:text-top; background-color:rgb(239,239,239)"> IBM</td> <td style="margin:0px; padding:5px 15px 5px 5px; border:1px solid rgb(170,170,170); vertical-align:text-top; background-color:rgb(239,239,239)"> 3532</td> </tr> <tr style="margin:0px; padding:0px; border:0px"> <td style="margin:0px; padding:5px 15px 5px 5px; border:1px solid rgb(170,170,170); vertical-align:text-top; background-color:rgb(239,239,239)"> Apple</td> <td style="margin:0px; padding:5px 15px 5px 5px; border:1px solid rgb(170,170,170); vertical-align:text-top; background-color:rgb(239,239,239)"> 4698</td> </tr> </tbody> </table> **注意:**在以上的结果中有两个相等的公司名称 (W3School)。只有这一次,在第一列中有相同的值时,第二列是以升序排列的。如果第一列中有些值为 nulls 时,情况也是这样的。
还没有评论,来说两句吧...