How to write a query in MySQL to sort by value?

Question

There is a sign saying:



Tell me how to make a request that would be sort by price ascending, but the elements from which qt = 0 to deduce the last one?

That is, in the end I want to get this result:

Answer 1

try

SELECT * FROM TBL_MYTABLE WHERE qt > '0' ORDER BY price
UNION  SELECT * FROM TBL_MYTABLE WHERE qt = '0' ORDER BY price