SELECT Min(id),Min(date) FROM a GROUP by (UNIX_TIMESTAMP(date) DIV 120) 该语句是指将时间分为每2分钟为一个区间,并查询每个区间的最小id及date