Rownumber/Rank a result set

• rhd110

  Ten Centuries

  Points: 1062

  More actions

  March 14, 2010 at 6:09 am

  #230860

  Friends, I have a resultset where I have EmployeeID, EmpName

  EmployeeID EmpName

  1 ABC

  1 ABC

  1 ABC

  2 LMN

  2 LMN

  3 PQR

  4 XYZ

  5 DEF

  5 DEF

  I want to row_number()/ rank() the EmployeeID in the following manner

  RowID,EmployeeID EmpName

  11 ABC

  21 ABC

  31 ABC

  12 LMN

  22 LMN

  13 PQR

  14 XYZ

  15 DEF

  25 DEF

• Paul White

  SSC Guru

  Points: 150467

  More actions

  March 14, 2010 at 6:36 am

  #1133381

  ROW_NUMBER() OVER (PARTITION BY employee_id ORDER BY employee_id)

  Paul White
  SQLPerformance.com
  SQLkiwi blog
  @SQL_Kiwi