Querying Data (get Max data Each group)

Question

2.00/5 (1 vote)

See more:

The data are shown below.

VB

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

Posted 5-Jul-11 21:31pm

z4rk

Add a Solution

2 solutions

Solution 2

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

Posted 5-Jul-11 21:43pm

z4rk

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Toniyo Jackson · Accepted Answer · 2011-07-05T21:35:00

Solution 1

Try this.

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

Posted 5-Jul-11 21:35pm

Toniyo Jackson

v2

Comments

z4rk 8-Jul-11 0:07am

Thanks.

Querying Data (get Max data Each group)

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Querying Data (get Max data Each group)

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us