修复Sql查询错误 [英] fixing Sql query error

问题描述

你好。我正在处理我的项目，我必须创建一个SQL查询来实现我的目标。但不幸的是，当我运行查询时出现错误。



这是我的Sql查询：

Hello . i am working on my project and i have to create a sql query to achieve my aims. but unfortunately i get an error when i run the query.

here is my Sql query :

select ROW_NUMBER()
OVER (ORDER BY Advertisement.AdsDate asc ) AS AdsIndex
,Advertisement.AdsId , Advertisement.AdsEnTitle from Advertisement
where Advertisement.Status=N'True' and AdsIndex<=17 and AdsIndex>=11

错误：

Error :

Invalid column name 'AdsIndex'.

如何解决我的问题？

how should i solve my problem ?

推荐答案

尝试：

Try:

SELECT AdsIndex, AdsId, AdsEnTitle 
FROM (SELECT *, ROW_NUMBER() OVER (ORDER BY Advertisement.AdsDate ASC) AS AdsIndex
      FROM Advertisement)
WHERE Status=N'True' AND AdsIndex<=17 AND AdsIndex>=11

这篇关于修复Sql查询错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！