Home  >  Article  >  Database  >  mysql关于热题的sql语句

mysql关于热题的sql语句

WBOY
WBOYOriginal
2016-06-06 09:39:141140browse

mysql

有这么个需求,有一张问题表,有问题的创建时间 datetime 还有一个评论数 count

现在我需要根据这个公式来进行排序 count/这条记录存在的时间

这条记录存在的时间指的是现在时间减去创建时间,不知道这个怎么实现,求高手帮忙,时间急迫

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn