SQL Server—在一列中不同的情况，但在第二列中最后一条记录

I have a requirement (simple, but can't find simple solution) to fetch mobile number and unique transaction id (latest transaction would be good, but any transaction id is also ok)I have a requirement (simple, but can't find si