文章浏览阅读645次。drop table if exists salaries ;CREATE TABLE salaries (emp_no int(11) NOT NULL,salary int(11) NOT NULL,from_date date NOT NULL,to_date date NOT NULL,PRIMARY KEY (emp_no,from_date));INSERT INTO salaries VALUES(10001,88958,‘2002-06-22’,‘9999-01-01’);_tmp.salary...
文章浏览阅读169次。题目描述首先这是一张原始表,包含公司id,员工id,员工名字,以及工资。题目要求,将工资调整为税后工资。具体的税收标准为:The tax rate is calculated for each company based on the following criteria:0 If the max salary of any......
文章浏览阅读472次。题目描述查找当前薪水(to_date='9999-01-01')排名第二多的员工编号emp_no、薪水salary、last_name以及first_name,不准使用order byCREATE TABLE `employees` (`emp_no` int(11) NOT NULL,`birth_date` date NOT NULL,`first_name` varchar(14..._获取当前......