题解 | 计算薪资涨幅
计算薪资涨幅
https://www.nowcoder.com/practice/fb9fe416067d4949b6355e9882fa98d3
select 雇员编号,max(薪水)-min(薪水) as 薪水涨幅 from 薪水表 group by 雇员编号 having max(结束日期) = '2004-01-01'
计算薪资涨幅
https://www.nowcoder.com/practice/fb9fe416067d4949b6355e9882fa98d3
select 雇员编号,max(薪水)-min(薪水) as 薪水涨幅 from 薪水表 group by 雇员编号 having max(结束日期) = '2004-01-01'
相关推荐
查看27道真题和解析