select top 10 * from yourtable A
where id in (select top 2 * id from yourtable where supply = A.supply order by addtime desc)
where id in (select top 2 * id from yourtable where supply = A.supply order by addtime desc)
where a.supply=b.supply and a.addtime<=b.addtime ) <=2
order by addtime
断线拉!!
where a.supply=b.supply and a.addtime<=b.addtime ) <=2
order by addtime
断线拉!!