请教一个查询吧

apache_test

试试：select aa.* from a as aa,(select account,max(day) as day from a group by account)as bb where aa.day=bb.day and aa.account=bb.account;

cenalulu

我建议还是改结构，至少要增加一列 自增的primary key，方便作为唯一reference。毕竟用（account+date）作为reference 效率太低了。。。

chenyx

select account,click,max(day) as mday group by account;

ruochen

select account,click,max(day) as mday group by account;
chenyx 发表于 2010-02-12 12:25

     首先LZ应该能写出这样的吧