当前记录的上一条和下一条记录

下一条:select top 1 * from abc where id>555 order by id asc
上一条:select top 1 * from abc where id <555 order by id desc
posted @ 2010-08-29 11:07  94cool  阅读(172)  评论(0)    收藏  举报