select a.id,a.name1,a.name2,b.createtime from table1 a
(select name2,max(createtime) createtime from table1 group by id) b
where a.name2=b.name2 and a.createtime=b.createtime
(select name2,max(createtime) createtime from table1 group by id) b
where a.name2=b.name2 and a.createtime=b.createtime
(select name2,max(createtime) createtime from table1 group by id) b
where a.name2=b.name2 and a.createtime=b.createtime and a.name1='li'
(select name1,name2,max(createtime) as createtime from table1 group by name1,name2) b
where a.name1=b.name1 and a.name2=b.name2 and a.createtime=b.createtime
还是说只要name1=li的数据??