摘要: 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 阅读(104) 评论(0) 推荐(0) 编辑