本文共 1318 字，大约阅读时间需要 4 分钟。

SELECT A.dept_no, emp_no, maxSalary FROM(SELECT dept_no, salaries.emp_no AS emp_no,salaryFROM salaries JOIN dept_empON salaries.emp_no = dept_emp.emp_no) AS AJOIN (SELECT dept_no, MAX(salary) AS maxSalaryFROM salaries JOIN dept_empON salaries.emp_no = dept_emp.emp_noGROUP BY dept_no) AS BON A.dept_no = B.dept_noWHERE salary = maxSalaryORDER BY A.dept_no;

select  e.emp_no,s.salary,e.last_name,e.first_namefrom employees e inner join salaries son e.emp_no = s.emp_nowhere s.salary = (select max(salary) from salaries WHERE salary<(select max(salary) from salaries) )

CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INTBEGIN    declare m INT;    set m=N-1;   RETURN (      # Write your MySQL query statement below.      SELECT Salary FROM Employee      GROUP BY Salary      ORDER BY Salary DESC      LIMIT m,1  );END

# Write your MySQL query statement belowSELECT a.Score,(SELECT COUNT(DISTINCT(Score)) FROM Scores AS b WHERE b.Score >= a.Score) AS 'Rank' FROM Scores AS aORDER BY a.Score DESC

排名函数

row_number()：依次递增排名，无重复排名

select *,   rank() over (order by 成绩 desc) as ranking,   dense_rank() over (order by 成绩 desc) as dese_rank,   row_number() over (order by 成绩 desc) as row_numfrom 班级

有的版本的MySQL不支持