补充第一种方法的另一种写法 select s.emp_no2 ,s.salary2 ,sum(s.salary1) from ( select s1.emp_no as emp_no1, s1.salary as salary1 , s2.emp_no as emp_no2, s2.salary as salary2 from salaries s1, salaries s2 where s1.to_date = '9999-01-01' and s2.to_date = '9999-01-01' and s1.emp_no <= s2.emp_no ) as s group by s.emp_no2,s.salary2
2

相关推荐

Java大菜狗:纯纯招黑奴,一天还不到两百那么多要求,还不迟到早退,以为啥啊,给一点工资做一堆活,还以不拖欠员工工资为荣,这是什么值得骄傲的事情吗,纯纯***公司
点赞 评论 收藏
分享
牛客网
牛客网在线编程
牛客网题解
牛客企业服务