i am trying to use RowNum keyword but SQL is giving error

Question

Hello, I am trying to use RowNum keyword in SQL query but it is giving me error when used in simple query where as same RowNum keyword is accepted in SQL sub query. I am sharing my screenshot below.

 

 

Thanks in advance.