SQL中遇到多条相同内容只取一条的最简单实现 如下:表timeand select * from timeand as a where not exists(select 1 from timeand where a.time = time and a.total<total);