mysql结果需要我的例子

Question

我在餐厅有桌子。我需要首先显示“开放餐厅”，然后关闭餐厅的结果，我还搜索邮政编码是2600。所以首先列出邮政编码2600 &然后是开业餐厅，然后是其他开业餐厅的邮政编码。然后是关闭餐厅的2600，然后是其他关闭餐厅的邮政编码。

restid  resname Zipcode status
    1   Res1    2600    Open
    2   Res2    2500    Closed
    3   Res3    3600    Closed
    4   Res4    2600    Open
    5   Res5    2500    Closed
    6   Res6    2600    Open
    7   Res7    3600    Open
    8   Res8    3600    Open
    9   Res9    2500    Closed
    10  Res10   2600    Closed

我需要像这样的结果。

restid  resname zipcode status
    1   Res1    2600    Open
    2   Res4    2600    Open
    3   Res6    2600    Open
    4   Res7    3600    Open
    5   Res8    3600    Open
    6   Res2    2500    Closed
    7   Res3    3600    Closed
    8   Res5    2500    Closed
    9   Res9    2500    Closed
    10  Res10   2600    Closed

提前谢谢。

Answer 1

select restid,resname,zipcode,status from sometable order by statys desc

Answer 2

您可以尝试以下解决方案：

SELECT restid,resname,zipcode,status FROM restaurant WHERE zipcode = 2600 ORDER BY status DESC;

这可能会对你有帮助。

Answer 3

尝试此查询以获得所需的输出。

select * from restaurant WHERE zipcode = 2600  order by status desc