达到分组排序后取最大那条数据的效果

SELECT DISTINCT
	`NAME`,
	`sex` 
FROM
	test_demo t 
WHERE
	sex = (
	SELECT
		max( t1.sex ) 
	FROM
		test_demo t1 
	WHERE
	t1.`name` = t.`name` 
	)