摘要: 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 阅读全文
posted @ 2010-07-01 08:25 neve 阅读(425) 评论(0) 推荐(0) 编辑