假设有如下字段
id score
1 10
1 20
1 40
2 20
2 50
3 33
3 66
3 99
3 11
现在要得出如下数组：["1":"30","2":"30","3":"88"]
或者得出各个id的最大值和最小值两个数组，要怎么写sql语句？
select level,MAX(score)-MIN(score) from t_score GROUP BY level
Select id,max(score),min(score) From T1 group by ID
select MAX(score)-MIN(score) from t_score