SQL 语法问题

Question

我一生都无法弄清楚这个 sql 语句有什么问题，

select top(1) 
  OrderNumber 
 from (select top(5) 
         OrderNumber 
       from SomeTable
       where TreePath='tests' 
       order by OrderNumber asc) 

有什么想法吗？

问候， 拜伦·科布.

Answer 1

您需要为派生表添加别名

select top 1 
  myDerivedTable.OrderNumber 
 from (select top 5 
         OrderNumber 
       from TABLE 
       where TreePath='tests' 
       order by OrderNumber asc) myDerivedTable
order by myDerivedTable.OrderNumber