to find all largest column with same column

Question

please see this table:

Answer 1

If I understand what you are looking for, then

;With cte As
(Select id, name, age,
  Row_Number() Over(Partition By age Order by name Desc) As rn
From <Your table name>)
Select id, name, age
From cte
Where rn = 1;

Tom

Answer 2

Thank you Tom,

I run your code, but the record name =f also be found. I just want two records that name =b and name=d.

Answer 3

To not get f, do

;With cte As
(Select id, name, age,
  Row_Number() Over(Partition By age Order by name Desc) As rn,
  Count(*) Over(Partition By age) As cnt
From <Your table name>)
Select id, name, age
From cte
Where rn = 1 And cnt > 1;

Tom

Answer 4

Thank you very much, I get the results. your code is right.