主要按照日期获得最新的数据;
今天记录两种方式,并不涉及效率等其他方面问题:
第一种, 利用GROUP BY原理:
select * from (
select * from `authenticationrecord` order by `authenticationtime` desc
) `temp` group by merchantrid order by `authenticationtime` desc
第二种,利用mysql内置函数
select * from `test` where id in(select SUBSTRING_INDEX(group_concat(id order by `date` desc),',',1) from `test` group by category_id ) order by `date` desc
<<<<<<<><>
试验脚本(自己玩):
create table STAFF(
id int,
sname varchar(50),
dept varchar(50),
salary int,
edlevel int,
hiredate datetime
)
insert into STAFF values('1','张三','开发部','2000','3','2009-10-11');
insert into S