按关键字段和条件把不完全重复(关键字段重复)筛选数据

1. 分区函数 partition by
2. 表数据
   
3. SQL

SELECT *
FROM (
	SELECT NAME
		,AGE
		,MAIL
		,TELL
		,row_number() OVER (
			PARTITION BY NAME ORDER BY AGE DESC
			) flag
	FROM STUDENT
	)
WHERE flag = 1;

4. 结果