上一页 下一页SQL语句

string preSql = "select * from [news] where news_id = (select MAX(news_id) from [news] where news_id<" + id + ")";
string nextSql = "select * from [news] where news_id = (select MIN(news_id) from [news] where news_id>" + id + ")";

posted @ 2011-03-01 20:19  王大湿  阅读(574)  评论(0编辑  收藏  举报