select
* from(select goodid,goodname,goodadrreds,goodprice,goodagio,(select
sum(GoodNum) from OrderDetailed where GoodID='x10001'), row_number() over(order
by goodid )as cc from goods where 1=1 and goodname like '%%' and goodname not
like '%爽肤水%' and GoodGround=0 )tall where cc between 1 and 10
错误消息:没有为
'tall' 的列 6 指定任何列。