摘要:
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]. 阅读全文