再sqlServer中
上一条 and 下一条 */
select top 1 p_title from t_photo where p_id<50 order by p_id desc
select top 1 p_title from t_photo where p_id>50 order by p_id asc
再oralce中
select test.* from (select *,rownum as rownum from Table) test
where test.rownum>50 and test.rownum<52