从trans_id中选择MAX( Bank_state )、Bank_state、`Forwarded_to`

Question

Trans_id    Bank_State  forwarded_to
70           15             1
71           16             2

SELECT MAX(trans_id)
     , Bank_state
     , Forwarded_to 
  FROM t_support_details 

是给了我结果

MAX(trans_id)  Bank_state  forwarded_to
           71          16             1

但结果应该是

MAX(trans_id)  Bank_state  forwarded_to
           71          16             2      

请帮帮我

Answer 1

你可以试试这个：

SELECT * FROM t_support_details 
ORDER BY trans_id DESC 
LIMIT 1

Answer 2

看看这个，简单又简单

SELECT *
FROM t_support_details 
WHERE id=(
    SELECT MAX(trans_id) FROM t_support_details 
    )

在寻找具有最大trans_id的行时，在此特定场景中使用where子句比尝试实现所需输出的方式要好得多:D。