22,206
社区成员
发帖
与我相关
我的任务
分享
declare @pjlx int
set @pjlx=1
SELECT TOP 1 *
FROM (SELECT row_number() OVER (ORDER BY a.pk) AS row, c.REALNAME, d .DMMC, a.*
FROM pjxxmx a, yhxxb c, dmb d
WHERE a.ccwlyr = c.userid AND d .dmlex = 'pjlx' AND a.pjlx = d .DMVALUE AND PJLX = @pjlx) t
ORDER BY row DESC
--TRY
SELECT TOP 1 *
FROM (SELECT row_number() OVER (ORDER BY a.pk) AS row, c.REALNAME, d .DMMC, a.*
FROM pjxxmx a, yhxxb c, dmb d
WHERE a.ccwlyr = c.userid AND d .dmlex = 'pjlx' AND a.pjlx = d .DMVALUE AND PJLX = 1) t where row between 1 and 16
ORDER BY row DESC