SQL取前后一条数据

取前一条

select top 1 * from Info where ID<" + 当前的ID号 + "  order by ID desc

取后一条

select top 1 * from Info where ID>" + 当前的ID号 + "  order by ID