SQL 面试题 （帮解决） - Oracle / 开发

有两个表 一个是
表：employee

表：salary


目前 要求 求出 人员 最后一个月的工资信息。

---

select a.*,b.* from emplyee a 
inner join salary b on b.employee_id = a.employee
where max(b.month)= b.month

---

SQL code:
select *
from (
select t.*,
row_number() over(partition by employee_id order by month desc) rn
from salary t
)
where rn = 1

---

select sum(salary) from salary
group by month
having month = 3

---

SQL code:
SELECT * from SALARY WHERE (EMPLOYEE_ID,MONTH) IN
(SELECT EMPLOYEE_ID,MAX(MONTH) from SALARY GROUP BY EMPLOYEE_ID)

---

select a.*,b.* from emplyee a  
inner join salary b on b.employee_id = a.id ---看错字段。
where max(b.month)= b.month

---

引用

select a.*,b.* from emplyee a
inner join salary b on b.employee_id = a.id ---看错字段。
where max(b.month)= b.month

有问题 

此处不允许处理 max(b.month)= b.month

---

SQL code:

With t As
(Select 1 eid,1 mon,10