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 110

题解 | #薪水第二多的员工，使用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 121

题解 | #获取每个部门中当前员工薪水最高的相关信息#

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 84

题解 | #验证IP地址#

if判断即可，保证输入字符正确，每组位数正确，每个IP组数正确，处理0和空串 class Solution { public: /** * 代码中的类名、方法名、参数名已经指定，请勿修改，直接返回方法规定的值即可 * * 验证IP地址 * @par...

2024-08-24

1 95