How to Order By two price columns?

Databases
1

Greetings,

I have a table with two columns “AuctionPrice” and “BINPrice”. Some Auctions also have a BINPrice too (Buy It Now Price).

I need to sort by lowest and highest prices, very similar to how eBay does it. This is what I’ve gotten so far:

ORDER BY AuctionPrice DESC, BINPrice DESC

This doesn’t seem to be working. I have a feeling both price columns need to be combined somehow but I’m not sure.

Let me know how this could be done.

Thanks

2

ORDER BY COALESCE(BINprice,AuctionPrice ) DESC

3

Awesome! Thanks a lot for the help.

Kind regards

4

so i made a lucky guess :slight_smile: