有min的mysql组

下面是表格数据(一小块)根基上我想查询凭证accoutn编号分组时具有最小original_date_ctr的行.

我实行过行使HAVING(MIN()),个中= Min()和其他方法没有命运.

这里的正确功效会给我id_ctr 688,1204和1209

id_ctr  account_number_cus  original_date_ctr   mrc_ctr  
------  ------------------  -----------------  ----------
   688               20062  2008-05-17             138.97
  1204              151604  2006-08-10           42000.00
  1209              151609  2006-06-29             968.68
  1367               20062  2011-10-27             207.88
  1434              151609  2009-09-10            1469.62
  1524              151604  2009-09-01           36999.99
  1585              151609  2012-05-31            1683.88

select t1.id_ctr,t1.account_number_cus,t1.original_date_ctr,t1.mrc_ctr  
from yourtable t1
inner join
(
    select min(original_date_ctr) as mindate,account_number_cus
    from yourtable
    group by account_number_cus
) t2
    on t1.account_number_cus = t2.account_number_cus
    and t1.original_date_ctr = t2.mindate

见SQL Fiddle with Demo

（编辑：湖南网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!