网上查了好几个,无一例外都失败(group by)
转则向distinct靠拢,利用distinct实现了去重排序。
select distinct url , name from (SELECT distinct url, name FROM table b where name= 'stu' order by date_time desc) a limit 4
网上查了好几个,无一例外都失败(group by)
转则向distinct靠拢,利用distinct实现了去重排序。
select distinct url , name from (SELECT distinct url, name FROM table b where name= 'stu' order by date_time desc) a limit 4