ms sql :select * from (select *from b) as xxx where 和 select * from (select *from b) xxx where區(qū)
select * from (select *from b) as xxx where…… 和 select * from (select *from b) xxx where……的區(qū)別
別告訴我是一樣的.
因為我有一個存儲過程
set @query= 'select *
from (select Food.*,Supplier.SupplierName,Row_number()over( '+@orderQuery+' ) as IDRank from '+@tableName+' ' +@checkQuery+' ) xx
where xx.IDRank between ……（省略了）'
這個是對的.
我改成
set @query= 'select *
from (select Food.*,Supplier.SupplierName,Row_number()over( '+@orderQuery+' ) as IDRank from '+@tableName+' ' +@checkQuery+' ) as xx
where IDRank between……（省略了）‘
之后,也可以執(zhí)行
但是如果改為
set @query= 'select *
from (select Food.*,Supplier.SupplierName,Row_number()over( '+@orderQuery+' ) as IDRank from '+@tableName+' ' +@checkQuery+' )
where IDRank between……（省略了）‘
就不能執(zhí)行了