Counter of Festivals

Ashok Blog for SQL Learners and Beginners and Experts

Tuesday, 29 October 2013

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: