string preSql = "select top 1 * from news where news_id < " + id + " order by news_id DESC" string nextSql = "select top 1 * from news where news_id > " + id + " order by news_id ASC" 这是表示查询下一条和上一条 sql记录的语句,那里面的id是怎么确定的,麻烦高手些解决下;说的是什么参数....?????
å¯ç¨row_numberæ¥è§£å³ã
å¦student表
id name create_date
1 å¼ ä¸ 2015-07-01
2 æå 2015-06-01
3 çäº 2015-08-01
4 èµµå 2015-04-01
å¦ï¼è¦æ¥æ¾å¼ ä¸çcreate_dateååååä¸æ¡æ°æ®ã
with t asç»æåºæ¯ï¼
id name create_date
2 æå 2015-06-01
3 çäº 2015-08-01