如题,distinct和group by不适用,只对表中某一字段排重但是查询结果中要包含所有的字段信息。
select * from (select id,userid,gjzy,xhsj,lrsj,wlbm,wlmc,wldw,wldj,wlnum,xhyy,jhdep,jx,qk ,
row_number()over(partition by gjzy order by userid desc,lrsj desc) rm from cb_rqrj_djclhs
where 1=1and jhdep = '100110011013' )a where a.rm=1
and userid = '1kwxdlxq' and substr(lrsj,1,4) between '2010' and '2010'
除了上面的实现方法还有什么方法能实现,通过子查询或内查询能实现么?!
|