摘要：
分组查最新条记录 select a.cur_id,a.old_exchange_rate,a.new_exchange_rate from fc_excrate_adjust a inner join (select cur_Id,max(pre_time)as preTime from fc_ex 阅读全文
摘要：
单字段去重复记录select * from fbs_corp_budget b WHERE b.corp_id IN ( SELECT d.corp_id FROM fbs_corp_budget d GROUP BY d.corp_id HAVING COUNT(d.corp_id) > 1) A 阅读全文