oracle虚拟出一个字段排序

[sql]代码库

SELECT
  c.*, CASE WHEN ceil((sysdate - create_date) * 24 * 60 * 60) <= (48 * 60 * 60) THEN ceil((sysdate - create_date) * 24 * 60 * 60) ELSE 0 END AS create_date_order
FROM
  cms c
ORDER BY
  create_date_order desc,
  read_times desc