苦逼面条

摘要： USE [MASTER]GOIF EXISTS (SELECT NAME FROM SYS.DATABASES WHERE NAME = N'EMPLOYEE TEST')DROP DATABASE [EMPLOYEE TEST]GOCREATE DATABASE [EMPLOYEE TEST]GOUSE [EMPLOYEE TEST]GOIF EXISTS (SELECT NAME FROM SYS.TABLES WHERE NAME = N'EMPLOYEE')DROP TABLE [EMPLOYEE]GOCREATE TABLE EMPLOYEE (EMP 阅读全文

摘要： select * from( select OrderId, Freight, ROW_NUMBER() OVER(order by Freight) as row from Orders ) a where row between 20 and 30 ... 阅读全文