![](https://img-blog.csdnimg.cn/20190918140012416.png?x-oss-process=image/resize,m_fixed,h_224,w_224)
SQL
SQL相关学习笔记
氧小氢
心怀浪漫宇宙,也珍惜人间日常
展开
-
牛客SQL刷题总结(三)
获取薪水第二高的员工的相关信息-- 方法一:使用窗口函数SELECT emp_no, salaryFROM (SELECT *, dense_rank() over(order by salary DESC) rnk FROM salaries)tmpWHERE rnk = 2 and to_date='9999-01-01';-- 方法二: 使用子查询(擅用GROUP BY)SELECT emp_no, salaryFROM salariesWHERE salary =..原创 2020-10-12 22:32:08 · 117 阅读 · 0 评论 -
牛客SQL刷题总结(二)
牛客SQL刷题总结(二)牛客每个人最近的登录日期问题A-- 方法一:SELECT user.name AS u_n, client.name AS c_n, login.date AS dFROM login INNER JOIN user ON login.user_id = user.idINNER JOIN client ON login.client_id = client.idWHERE (login.user_id,login.date) IN (SELECT user_id原创 2020-10-12 22:26:07 · 190 阅读 · 0 评论 -
牛客SQL刷题总结(一)
牛客SQL刷题总结使用SELECT查询创建表CREATE TABLE actor_nameSELECT first_name,last_name FROM actor;创建索引CREATE UNIQUE INDEX uniq_idx_firstname ON actor(first_name);CREATE INDEX idx_lastname ON actor(last_name);创建视图-- 方法一:CREATE VIEW actor_name_view AS原创 2020-10-12 12:13:18 · 318 阅读 · 0 评论 -
力扣SQL刷题总结
力扣SQL刷题总结多表查询用到的联结:内联结(INNER JOIN):取两表的公共数据;左联结(LEFT JOIN):联结结果保留左表的全部数据;右联结(RIGHT JOIN):联结结果保留右表的全部数据;查询第二高的薪水-- 方法一:使用子查询和LIMIT子句SELECT (SELECT DISTINCT Salary FROM Employee ORDER BY Salary DESC LIMIT 1 OFFSET原创 2020-10-10 14:55:22 · 548 阅读 · 0 评论