查询并排序1134方式

SELECT o.*,o.`payed`,(SELECT COUNT(s.payed)+1 FROM order_info s WHERE s.payed>o.payed) rank FROM order_info o ORDER BY o.payed DESC;