We have a credit card transaction table where each record has a transaction ID, the customer, the transaction time and the amount. Customer 101 spent 250 on March 1st, then 80 and 120 at exactly the same timestamp at 3 PM on March 5th. How would you write SQL to pull each customer's most recent transaction, and how do you handle two transactions at the same time?

有一张信用卡交易表，每笔记录了交易编号、客户、交易时间和金额；客户101在3月1日刷了250，3月5日下午3点同一时刻刷了80和120。我想拿到每个客户最近的一笔交易，你会怎么写SQL？同一时刻有两笔怎么办？