This topic created in 4866 days ago, the information mentioned may be changed or developed.
table中有几亿条数据 字段一 字段二
字段二group by分组去重
字段一求最大值
2 replies • 1970-01-01 08:00:00 +08:00
 |
|
1
lookhi Apr 18, 2013
SELECT TABLE2,MAX(TABLE1) FROM TABLE GROUP BY TABLE2
|
|
|
2
lookhi Apr 18, 2013
SELECT FIELD2,MAX(FIELD1) FROM TABLE GROUP BY FIELD2
|
Select Language