sql 列名 'row' 无效。

因为where

子句是在select

子句之前执行的，所以where

子句中不能用别名来过滤

可改为

select

*

from(

select

ROW_NUMBER()over(order

by

PRD_NO

desc)as

row,*

from

prdt)

as

T

where

row

=

1

要借助行号 (ta1:a,bta2:abc

sql 2000

select identity(int,1,1) id,t1.* into ta1 from t1

select identity(int,1,1) id,t4.* into ta2 from t4

select (select a from ta1 where b=ta2.a and id=ta2.id) a,ta2.b,ta2.c

from ta2

sql 2005以上或oracle 10g等支持排名函数的，可以直接把上表的ta1，ta2替换

如ta1

select row_number() over(order by (select 1)) as id,* from ta1您好!仅供参考，相互交流！有帮助考虑采纳一下。有空到软件测试基地,365testingncpyl

不能这么写，改一下

select * from (select *,ROW_NUMBER()OVER(order By item_id) as Row from T_ITEMS) as aaa where Row >2

这样就行了

---