【2017年整理】如果有重复数据,则取其中创建时间最大的那条.docx

需求：查询每期还款清单表中指定期次的详细信息，只要是 扣款日、应还本金、应还利息、实还本金、实还利息、交易时间 这个 6 个字段的值相同的话就显示创建时间最大的那条记录条件：银行为每笔贷款生产的唯一 id 、期次Sql:select m.t_withhold_day as 扣款日 m.n_get_pnpl as 应还本金,m.n_got_pnpl as 实还本金,m.n_get_itrt as 应还利息,m.n_got_itrt as 实还利息,m.n_get_pyat as getPyat,m.n_got_pyat as gotPyat,m.n_get_itre as getItre,m.n_got_itre as gotItre,m.t_recdat as 交易时间,m.c_abs as traAbs,m.t_crt_tm as crtmfrom tb_clm_mqhk_list mwhere 1 = 1and m.c_bank_pk = 'bank10000000000003060249'and m.N_TERM = '9'and m.t_crt_tm in (select max(t.t_crt_tm) from tb_clm_mqhk_list t where t.c_bank_pk = 'bank10000000000003060249'and t.N_TERM = '9' group by t.t_withhold_day,t.n_get_pnpl,t.n_got_pnpl,t.n_get_itrt,t.n_got_itrt,t.t_recdat)order by m.t_withhold_day desc;注意：在分组的时候不要在后面加 having 子句，否则只会返回一条结果。