mysql 按照计算值排序

SELECT title,browse_num/exposure_num as click_rate FROM `tf_news` ORDER BY browse_num/exposure_num desc

根据点击率进行排序。有点意思。

posted @ 2019-08-10 10:52  TBHacker  阅读(1578)  评论(0编辑  收藏  举报