Row_number() over(order by) Function Usage methods in Scripts

Row_number() over(order by) Function Usage methods in Scripts

When u use row_number() over usage u have to follow below methods other wise u can get error


sample table

select * from  testdb.[dbo].[Employee_Test]

When u use select without alias table then u can get Error as see below:

But u can select row_number() function with following two methods

Method 1:

Method 2: