SELECT Date
     , Invoice
     , ProductName
     , Qty
     , Rate
     , TotalPrice
     , PaymentStatus
     , PaymentType
  FROM xxxTable
 ORDER
    BY PaymentStatus = 'Due' DESC 
     , date DESC

这应按到期、已付和其他顺序排序：

SELECT Date, Invoice, ProductName, Qty, Rate, TotalPrice, PaymentStatus, PaymentType
FROM xxxTable
ORDER BY CASE 
    WHEN PaymentStatus LIKE "%Due%" then 1 
    WHEN PaymentStatus LIKE "%Paid%"  then 2 
    ELSE 3 
END

尝试：

select   *
   from     yourtable
   order by
            `Payment Status`
            ,Date desc