2011年11月7日
分页的sql语句。
摘要： select top 10 * from [Northwind].[dbo].[Orders] where OrderID NOT IN(SELECT top 20 OrderID from [Northwind].[dbo].[Orders] order by OrderID )order by OrderIDselect top 10 *from [Northwind].[dbo].[Orders] where OrderID >(selectISNULL(MAX(OrderID),0)FROM(selecttop 20 OrderID from [Northwind].[dbo]. 阅读全文
posted @ 2011-11-07 16:49 xiaoshiyilang 阅读(110) 评论(0) 推荐(0)