有如下的select语句:CREATE TABLE
(
EmployeeID INT PRIMARY KEY IDENTITY(1,1),
Age INT,
EmployeeName NVARCHAR(20),
EmployeeAddress NVARCHAR(200)
)select top 10 from dbo.Employees order by EmployeeName descorder by是在整个Employees表上排序,然后取前十,还是先取前十,然后再给这十个记录排序?
(
EmployeeID INT PRIMARY KEY IDENTITY(1,1),
Age INT,
EmployeeName NVARCHAR(20),
EmployeeAddress NVARCHAR(200)
)select top 10 from dbo.Employees order by EmployeeName descorder by是在整个Employees表上排序,然后取前十,还是先取前十,然后再给这十个记录排序?
select top 10 * from dbo.Employees order by EmployeeName desc
SELECT ROW_NUMBER() OVER (ORDER BY EmployeeID) AS RowNo, * INTO #QueryResults FROM dbo.Employees
select * from #QueryResults where RowNo between 11 and 20 order by EmployeeName desc
这就是先取RowNo在10~20的,然后再给这10个按照名字逆序排序?