SQL
江小北
每想你一次,天上飘落一粒沙,从此形成了撒哈拉。每想你一次,天上就掉下一滴水,于是形成了太平洋。
展开
-
SQL(六)
SELECT last_name, first_name, departments.dept_name FROM (SELECT employees.emp_no, last_name, first_name, dept_no FROM employees LEFT JOIN dept_emp ON employees.emp_no = dept_emp.emp_no) AS a LEFT JOIN departments ON a.dept_no = departments.dept_no原创 2021-05-04 11:55:17 · 96 阅读 · 0 评论 -
SQL(五)
索引数据结构红黑树,Hash,B+树详解 索引是帮助MySQL高效获取数据的排好序的数据结构原创 2021-05-01 22:48:36 · 90 阅读 · 0 评论 -
SQL(四)
# Write your MySQL query statement below SELECT Department.Name AS Department, e1.Name AS Employee, Salary FROM Employee e1 INNER JOIN Department ON e1.DepartmentId = Department.Id where 3 > ( select count(distinct e2.Salary) from Employee e2 where e2..原创 2021-04-29 12:31:48 · 91 阅读 · 0 评论 -
SQL(三)
180. 连续出现的数字 暴力三表连接 # Write your MySQL query statement below SELECT DISTINCT(l1.Num) AS ConsecutiveNums FROM Logs l1, Logs l2, Logs l3 WHERE l1.Id = l2.Id - 1 AND l2.Id = l3.Id - 1 AND l1.Num = l2.Num AND l2.Num = l3.Num ..原创 2021-04-26 21:32:37 · 116 阅读 · 0 评论 -
窗口函数+经典topN问题SQL笔记
SQL窗口函数 这类问题其实就是常见的:每组最大的N条记录(topN)。 问题:查找每个学生成绩最高的2个科目原创 2021-04-26 21:14:40 · 333 阅读 · 2 评论 -
SQL(二)
SELECT A.dept_no, emp_no, maxSalary FROM (SELECT dept_no, salaries.emp_no AS emp_no,salary FROM salaries JOIN dept_emp ON salaries.emp_no = dept_emp.emp_no) AS A JOIN (SELECT dept_no, MAX(salary) AS maxSalary FROM salaries JOIN dept_emp ON salaries.emp_n..原创 2021-04-25 16:30:46 · 74 阅读 · 0 评论 -
SQL(一)
查询语句包含部分: select … from … where … group by … having … order by … limit ;原创 2021-04-16 22:59:17 · 97 阅读 · 0 评论