获取当前薪水第二多的员工的emp_no以及其对应的薪水salary
https://www.nowcoder.com/practice/c1472daba75d4635b7f8540b837cc719
select s.emp_no,s.salary,last_name,first_name
from
employees e
inner join
salaries s
on e.emp_no=s.emp_no
having s.salary=(select max(s1.salary) from salaries s1
where s1.salary<(
select max(s2.salary) from salaries s2
))
这道题恶心就恶心在需要用group by ，但明显是一个无意义的操作。
记得要用group by 后面加上 你join 的字段，不然会报错
#23届找工作求助阵地#相关推荐
球球与墩墩：这不是前端常考的对象扁平化吗，面试官像是前端出来的
const flattern = (obj) => {
const res = {};
const dfs = (curr, path) => {
if(typeof curr === 'object' && curr !== null) {
const isArray = Array.isArray(curr);
for(let key in curr) {
const newPath = path ? isArray ? `${path}[${key}]` : `${path}.${key}` : key;
dfs(curr[key], newPath);
}
} else {
res[path] = curr
}
}
dfs(obj);
return res;
}
查看3道真题和解析 招聘动态
