SqlSelect-记录搜索

1.开头到N条记录
Select Top N * From 表
-------------------------------
2.N到M条记录(要有主索引ID)
Select Top M-N * From 表 Where ID in (Select Top M ID From 表) Order by ID Desc
----------------------------------
3.N到结尾记录
Select Top N * From 表 Order by ID Desc
posted @ 2007-09-11 14:38  yellowwood  阅读(165)  评论(0编辑  收藏  举报
Never Give UP