id aid title
1 4 aaaaaaaaaaa
2 5 bbbbbbbbbbb
3 4 ccccccccccc
4 4 ddddddddddd如上的数据,我只知道id=3和aid=4,怎样查出aid=4的上一页数据和下一页数据呢?想实现原功能是浏览一编文章时的结尾显示上一页:aaaaaaaa,下一页:ddddddddd方便浏览~~~
不知讲得清吾清楚....
1 4 aaaaaaaaaaa
2 5 bbbbbbbbbbb
3 4 ccccccccccc
4 4 ddddddddddd如上的数据,我只知道id=3和aid=4,怎样查出aid=4的上一页数据和下一页数据呢?想实现原功能是浏览一编文章时的结尾显示上一页:aaaaaaaa,下一页:ddddddddd方便浏览~~~
不知讲得清吾清楚....
Select * From TableName
Where id < 3--之後的數據
Select * From TableName
Where id >3
Where id < 3
Order By idSelect TOP 1 title From TableName
Where id > 3
Order By id Desc
--Result
/*
aaaaaaaaaaaddddddddddd
*/
Select TOP 1 title From TableName
Where id < 3
Order By id) A
Union All
Select * From(
Select TOP 1 title From TableName
Where id > 3
Order By id Desc) A
Select * From(
Select TOP 1 title From TableName
Where id < 3
Order By id
Union All
Select TOP 1 title From TableName
Where id > 3
Order By id Desc) A