ROW_NUMBER() OVER (order by ee) 不能用别名

[codetian]

执行正确：
SELECT * FROM (SELECT ROW_NUMBER() OVER (order by Username ) AS pos, Username FROM P_User ) AS sp WHERE pos BETWEEN 1 AND 2

执行出错：
order by ee 使用了别名 ee

SELECT * FROM (SELECT ROW_NUMBER() OVER (order by ee) AS pos, Username as ee FROM P_User ) AS sp WHERE pos BETWEEN 1 AND 2

ROW_NUMBER() OVER (order by ee) 不能用别名??

[好汉坡]

别名ee在哪用的？

[--小F--]

SELECT
 * 
FROM 
  (SELECT pos=ROW_NUMBER() OVER (order by Username)  , Username as ee FROM P_User )  AS sp 
WHERE 
  pos BETWEEN 1 AND 2

[快乐_石头]

不能~~

[icelovey]

SELECT * FROM (SELECT ROW_NUMBER() OVER (order by Username ) AS pos, Username FROM P_User ) AS sp WHERE pos BETWEEN 1 AND 2 

OVER里面的ORDER BY是不能使用别名的

[drysea]

...

[kasin000]

ee 改成Username

[laker_914]

肯定不能撒

[Ray_Zhang]

ROW_NUMBER() OVER 里只能用原字段名不能用别名。