sql，按照时间排序，取前N条

最新推荐文章于 2023-07-18 16:32:10 发布

R芮R

最新推荐文章于 2023-07-18 16:32:10 发布

阅读量1.4k

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/dk1024/p/11057720.html

版权

mysql：
SELECT * from 
(SELECT H_TEMPERATURE,TH_TIME FROM wenshidu 
WHERE TH_TIME <= STR_TO_DATE('2016-03-16 10:04:52','%Y-%m-%d %H:%i:%s')
order by  TH_TIME desc)  as total limit 0,8;
 
oracle：
SELECT * from 
(SELECT H_HUMIDITY FROM HOME_MONITOR 
WHERE H_TIME <= to_date( ' 2016-03-01 10:04:52 ' ,'yyyy-MM-dd HH24:mi:ss')   
order by  H_TIME desc ) where rownum<=8;