We have a table of employees and another table showing their role history. The history table has an effective date from when the role started. Finding an employees current role is trivial, but I am having issues finding their role at a certain point in time.We have a table of employees and another table
阅读背景：
SQL：根据生效日期查找值
来源：互联网
分享到：
