SELECT *
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
我这个可以查出很多数据,但是我只想要row的最后一行。是不是用count?怎么用?
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
我这个可以查出很多数据,但是我只想要row的最后一行。是不是用count?怎么用?
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
order by
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
order by row desc
(select 1 from tb where id>a.id)