这句话哪里错了，想查询第1441条记录
- SQL code
select * from ( select row_number() over(order by 语文 desc) as px,语文 from scores_xx ) where px = 1441
[解决办法]
- SQL code
select * from ( select row_number() over(order by 语文 desc) as px,语文 from scores_xx ) t where px = 1441
发布时间： 2012-06-24 18:32:37 作者： rapoo
这句话哪里错了，想查询第1441条记录
select * from ( select row_number() over(order by 语文 desc) as px,语文 from scores_xx ) where px = 1441
select * from ( select row_number() over(order by 语文 desc) as px,语文 from scores_xx ) t where px = 1441