select top 1* from tablename where id not in (select top 1 id from tablename where time < 13:30 order by time desc) and time < 13:30 order by time desc
去掉最高的那条就行了,1你可以改成任意数值
-- 用一个子查询 ,先取第次小、二小 两条记录(top 2 ) ,再反向排序,取第一个 top 1
-- 大概如下,没有测试过。
select top 1 * from (select top 2 from t where time >'111' order by time desc) x order by time asc