select 工号,姓名,性别,江湖,银两 from (
select a.emnum 工号,c.nickname 姓名,decode(c.sex,0,'男',1,'女') 性别, max(a.amount) 江湖,max(b.yin) 银两 from boss_hr_jianghu_yinliang a
left join boss_hr_jianghu_point b
on a.emnum = b.emnum
left join boss_hr_temp_relating c
on b.emnum = c.emnum
where 1=1
group by a.emnum,c.nickname,c.sex
order by b.yin desc
)
一个人有多条记录,江湖和银两有多有少,我只想显示每个人江湖和银两最多的那条记录
|