sql需要先排序后分组解决思路

在mysql中，同时出现group by 和 order by，需要先group by后order by，但是这样的话有些情况就无法查找出正确的内容，比如说需要查找同一个名称中最新的修改记录

SELECT
	* 
FROM
	(
SELECT
	participle.cid AS cid,
	word,
	word_frequency AS wordFrequency,
	is_up AS isUp,
	core_word AS coreWord,
	importance,
	part_of_speech AS partOfSpeech,
	NAME,
	check_time AS checkTime 
FROM
	participle,
	laws_logs 
WHERE
	participle.cid = laws_logs.participle_cid 
ORDER BY
	check_time DESC 
	) a 
GROUP BY
	word

解决思路是先在内部进行order by排序之后，再外面包一层group by进行分组即可