Mysql Go Heavy

There are terabytes of tables with table data as follows:

Id	Name	Age	Time
1	Tom	20	2012-12-12
2	John doe	22	2013-01-12
3	Harry	22	2014-04-23
4	Tom	20	2014-04-22
5	Tom	20	2011-12-12
6	John doe	22	2015-01-12

Issue 1: Get Data name, age and remove duplicate name fields
For:
Select distinct name,age from TB;
The result of the query is
Name age
Zhang 320
Lee 422
Wang 522

Question 2: Want to isolate the Id,name,age,time field and remove duplicates with the Name field

Answer: At this time with distinct is not, use the following statement
SELECT * from TB as a where id= (select ID from TB where a.name=name limit 0,1)

This method is OK, but the number is very large, it takes time, not a good choice

It would be nice to use GROUP by.

SELECT * from TB GROUP by name

Mysql Go Heavy