摘要:
select * from protype where id in (select top {0} id from (select top {1} id from protype where tid=" + id + " order by id desc) as t order by t.id desc) order by id desc请看上面的一条sql语句,经测试执行顺序为当然是在access中,因为,我觉得sqlserver中可能会不一样!①select top {1} id from protype where tid=" + id + " o 阅读全文