@TOC

Leetcode

  • 查询第二高的薪水
    select max(salary) as SecondHighestSalary 
from employee 
where salary < (select max(salary) 
from employee) 
    select max(salary) as SecondHighestSalary 
from employee where salary < (select max(salary) 
from employee)

-查询第N高的薪水