你时间差需要有一个字段记录时间，假设叫timeselect distinct(column_name),count(1) as num from table_name where time between time1 and time2 having num > 1 order by num
