查询每一组的最新的一条数据

SELECT t.id, t.source_primary_key, t.create_time FROM oydc_data_center t
	WHERE NOT EXISTS (
	SELECT t2.* FROM `oydc_data_center` t2
	WHERE t2.source_primary_key = t.source_primary_key
	AND t2.create_time > t.create_time
)