个人练习仅供参考
1、第二高的薪水
数据
CREATE TABLE IF NOT EXISTS Employee (id int, salary int);
TRUNCATE TABLE Employee;
INSERT INTO Employee (id, salary) VALUES ('1', '100');
INSERT INTO Employee (id, salary) VALUES ('2', '200');
INSERT INTO Employee (id, salary) VALUES ('3', '300');
代码
select * from Employee order by salary desc limit 1,1;
2、过去30天的用户活动II
数据
CREATE TABLE IF N