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