--这样试试 select * from (select t.*,row_number() over(order by abs(时间字段-时间点timestamp))rn from tablename ) where rn<=10
select * from (select t.*,row_number() over(order by SUBSTR((时间字段-时间点timestamp),2))rn from tablename ) where rn<=10 abs不能用在timestamp差值上,用substr除去符号位再做比较
select * from
(select t.*,row_number() over(order by abs(时间字段-时间点timestamp))rn
from tablename )
where rn<=10
(select t.*,row_number() over(order by SUBSTR((时间字段-时间点timestamp),2))rn
from tablename )
where rn<=10
abs不能用在timestamp差值上,用substr除去符号位再做比较