需求:查找rec_date为最新的数据
SELECT
a.*
FROM
ws_client_invoice_record_v1 a
INNER JOIN (
SELECT
inv_id,
max( rec_date ) rec_date
FROM
ws_client_invoice_record_v1
GROUP BY inv_id ) b
ON ( a.inv_id = b.inv_id AND a.rec_date = b.rec_date )