查询数据(每组获取最大数据)

问题描述

数据如下所示.

The data are shown below.

playerNo Score
1       100
1       110
1       120
1       130
1       140
1       150
2       100
2       200
2       300
3       100
3       120
3       104
3       160
4       110
4       106
4       140
5       110
5       120
5       140

结果如下所示.

The result should be shown in following.

playerNo  Score
1         150
2         300
3         160
4         140
5         140

推荐答案

select playerNo, MAX(Score) from tablename group by playerNo

SELECT distinct playerNo,(SELECT Max(score) AS score FROM table1 as a WHERE a.playerNo = b.playerNo) FROM table1 AS B

这篇关于查询数据(每组获取最大数据)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！