How to Rank this...

• stiej1977

  Ten Centuries

  Points: 1134

  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: 247180

  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?

  ---