22,210
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE test(id int,name char(1))
GO
DECLARE @string varchar(26)
DECLARE @count int,@length int
SET @string='ABCDEFGHIJKLMNOPQRSTUVWXYZ'
SET @length=len(@string)
SET @count=1
while(@count<=@length)
begin
insert into test values (@count,substring(@string,@count,1))
SET @count=@count+1
end
--第2页 每页3条
DECLARE @pageindex int,@pagesize int
SET @pageindex=2
SET @pagesize=3
DECLARE @page int
SET @page=(@pageindex-1)*@pagesize
select top 3 * from test
where id not in (select top (@pagesize) id from test)
SELECT TOP 20 * FROM [VW_SYS_TASKS_MYPROCESSED]
WHERE [TASK_ID ] <(
SELECT MIN([TASK_ID ])
FROM
(SELECT TOP 800 [TASK_ID]
FROM [VW_SYS_TASKS_MYPROCESSED]
where PRC_ProcUser=N'hwtong') AS TBLTMP
)
AND (PRC_ProcUser=N'hwtong')
ORDER BY [TASK_ID ] DESC
SELECT MIN([TASK_ID ])
FROM (
SELECT TOP 800 [TASK_ID ]
FROM [VW_SYS_TASKS_MYPROCESSED]
where (PRC_ProcUser=N'hwtong'
)
ORDER BY [TASK_ID ] DESC
這段代碼怪怪的,找最小的用min了,怎麼還要order by?