以下子查询别名为何起作用
Select Top 1 Salary From
(Select Distinct Top 3 salary From Employee Order by salary)
result
Order by salary
但这会产生语法错误
Select salary From Employee
Where salary < (Select Max(salary) From Employee)
result
Order by salary
以下子查询别名为何起作用
Select Top 1 Salary From
(Select Distinct Top 3 salary From Employee Order by salary)
result
Order by salary
但这会产生语法错误
Select salary From Employee
Where salary < (Select Max(salary) From Employee)
result
Order by salary