Need help in select query

• borra2005

  SSC Enthusiast

  Points: 150

  More actions

  April 23, 2010 at 3:41 am

  #231977

  Hi All,

  I have table of data as follows:

  20278123

  20278123

  20278123

  20329456

  20329456

  20329456

  20421919

  20421919

  20421920

  I have to write a select query to get data like below:

  20278123 1

  20278123 2

  20278123 3

  20329456 1

  20329456 2

  20329456 3

  20421919 1

  20421919 2

  20421919 1

  Please help me in writing the query.

  Thanks in adavance,

  Ravi.

• Tom257

  SSChampion

  Points: 11543

  More actions

  April 23, 2010 at 3:48 am

  #1156683

  Check out this article http://www.sqlservercentral.com/articles/T-SQL/69717/

  You should end up with something like

  SELECT DATE, ROW_NUMBER() OVER(PARTITION BY Date ORDR BY Date) AS RN

• borra2005

  SSC Enthusiast

  Points: 150

  More actions

  April 23, 2010 at 3:53 am

  #1156684

  Thank you so much, it works.