--Order by is required, Partision by is optional --when data is partioned row number is reset to 1 when partision changes select * from Customers select Cust_Name,Gender,Salary, row_number () over ...