JoShamash
JoShamash
全部文章
分类
归档
标签
去牛客网
登录
/
注册
JoShamash的博客
全部文章
(共4篇)
题解 | #查找在职员工自入职以来的薪水涨幅情况#
select T1.emp_no as emp_no, T2.salary-T1.salary as growth from (select # 每个员工的最早的薪水情况 A.emp_no, salary from salaries as A inner join (...
2024-08-31
1
105
题解 | #薪水第二多的员工,使用max比较#
select A.emp_no, salary as salary, last_name, first_name from employees as A inner join salaries as B on A.emp_no = B.emp_no w...
2024-08-27
1
118
题解 | #获取每个部门中当前员工薪水最高的相关信息#
SELECT T1.dept_no, T1.emp_no, T2.maxSalary FROM ( SELECT A.dept_no, A.emp_no, B.salary FROM dept_emp AS A INNER JOIN salaries AS B ON A.em...
2024-08-26
1
80
题解 | #验证IP地址#
if判断即可,保证输入字符正确,每组位数正确,每个IP组数正确,处理0和空串 class Solution { public: /** * 代码中的类名、方法名、参数名已经指定,请勿修改,直接返回方法规定的值即可 * * 验证IP地址 * @par...
2024-08-24
1
91