求一条分组求最大值的sql语句

[kenneth]

table中有几亿条数据 字段一 字段二
字段二group by分组去重
字段一求最大值

[lookhi]

SELECT TABLE2,MAX(TABLE1) FROM TABLE GROUP BY TABLE2

[lookhi]

SELECT FIELD2,MAX(FIELD1) FROM TABLE GROUP BY FIELD2