How to Rank this...

• stiej1977

  Ten Centuries

  Points: 1132

  More actions

  January 29, 2024 at 12:49 pm

  #4369548

  I'm failing to write a suitable rank function to label the following select resultset as seen here. I want my RankNumber column to be as set out here...

  

  Basically for each account id, i want to sequentially number the rows from 1 to X and the number needs to change only when the accountowner changes. Each row for each account needs to be ordered in "LastModifiedDate" DESC order first.

   

• Phil Parkin

  SSC Guru

  Points: 246976

  More actions

  January 29, 2024 at 2:02 pm

  #4369593

  Would you please provide your sample data in the form of CREATE TABLE / INSERT statements?

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel