您可以只运行2个查询作为内部查询以返回2列:
select (SELECT MAX(Salary) FROM Employee) maxsalary, (SELECt MAX(Salary) FROM Employee WHERe Salary NOT IN (SELECt MAX(Salary) FROM Employee )) as [2nd_max_salary]
SQL小提琴演示

您可以只运行2个查询作为内部查询以返回2列:
select (SELECT MAX(Salary) FROM Employee) maxsalary, (SELECt MAX(Salary) FROM Employee WHERe Salary NOT IN (SELECt MAX(Salary) FROM Employee )) as [2nd_max_salary]
SQL小提琴演示