select *, row_number()over (order by customer) as num from TableA where num>1

这个执行的时候说num不存在

select * from (select *, row_number()over (order by customer)as num from TableA ) a where a.num>1
一般是这样写的，，我问下为什么那样写不可以呢。求指点