Finapp select row_number() over(partition by State, CountName order by DateTime desc) as RowNum, * from OFAReporting RowNum System.Int64 state System.String CountName System.String Value System.Int64 DateTime System.DateTime