SQL查询查找事实表中的趋势

我想你想要 lag() :

select t.*
from (select t.*, lag(value) over (partition by entity_id order by date) as prev_value
      from t
     ) t
where prev_value > value;

您可以添加 and date >= '2014-01-01' and date <= '2014-01-04'

MySQL中的范围仅为<或>或者=您可以根据需要组合它们,但仍然可以使用LIke%date%来检索类似的日期

假设你的桌子 entity

SELECT e.entity_id, e.value as old_value, e2.value as new_value, v2.date
FROM entity e
JOIN entity e2 ON v.entity_id = v2.entity_id
AND e.date < e2.date
AND e.value > e2.value
GROUP BY e.date