#mySQL# 关于sum计算后依据sum排序 $sql="select *,SUM(book_times) as sum from book group by book_ISBN order by sum desc";