Option Explicit 声明Windows API函数 Declare PtrSafe Function SetWindowsHookEx Lib "user32" Alias "SetWindowsHookExA" (ByVal idHook As Long, ByVal lpfn As Long, ByVal hMod As Long, ByVal dwThreadId As Long) As LongPtr Declare PtrSafe Fu…
185.部门工资前三高的所有员工
考察点:窗口函数的使用
select d.name as Department ,t.name as Employee,t.salary as Salary
from (select* ,DENSE_Rank() over(PARTITION BY departmentId order by salary DESC) as rank_idfrom Employee
) t join Department …