题解 | #获取当前薪水第二多的员工的
获取当前薪水第二多的员工的emp_no以及其对应的薪水salary
https://www.nowcoder.com/practice/8d2c290cc4e24403b98ca82ce45d04db
select
s3.emp_no,
s3.salary
from
salaries s3
where
s3.salary = (
select
Max(s1.salary)
from
salaries s1
where
s1.salary <> (
select
Max(s2.salary)
from
salaries s2
)
)
order by
s3.emp_no
分享一道面试题：
function getMyWechatCode() {
const firstName = 'Jeriah';
const lastName = 'Lee';
console.info(`My WC_code is ${firstName}-${lastName}`); // you can contact me.
}
