SQL 分页

select top 10 * from inventTable Order By ItemID
select top 5 * from inventTable order by ItemID
select top 5 *
    from inventTable
    where RecID not in(select top 5 RecID
                            from InventTable Order By ItemID)
    Order By ItemID

posted @ 2011-12-20 11:51  perock  阅读(139)  评论(0编辑  收藏  举报