CODEWITHSUNDEEP
mysql
mikejohnvino
mikejohnvino

Reputation: 95

mysql result need to my example

I have restaurant table. I need to show first "open restaurants" & then closed restaurants result and also I searched zipcode is 2600. so fisrt list zipcode 2600 & then open restaurants then other zipcode of open restaurant. Then 2600 of closed restaurant then other zipcode of closed restaurant.

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

I need the result like...

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

Thanks in advance.

Upvotes: 1

Views: 44

Answers (3)

Syed mohamed aladeen
Syed mohamed aladeen

Reputation: 6755

Try this query for your desired output.

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

Upvotes: 0

Harsh Sanghani
Harsh Sanghani

Reputation: 1712

You can try following solution :-

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

It may help you.

Upvotes: 0

Parviz Rozikov
Parviz Rozikov

Reputation: 259

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

Upvotes: 1

Related Questions