Add a Column to Sequentially Rank Records

 

Problem Description:

How to Add a Column to Sequentially Rank records?

Customer wants to assign a ranking number for each Row to only select, (for example) a customer's last three trips.  

The Select is sorted by Customer Number, and each Date for that customer needs to have a 'RANK' starting at 1 like this example:

Solution:

Need to use the RANK Function within the Query like so:

RANK( ) OVER(PARTITION BY SYIDTH ORDER BY HDARTH DESC) AS COLUMN0000