选择一列的TOP 1，按重复ID和其他唯一字段进行分组

I am struggling with a query of data I need just one row of for EACH account in a table (thousands), based on selecting the highest sequence in a different column (Account_Occupant).I am struggling with a query of data I need jus