Querry prob.

[Ewoud]

Hi,

I'am searching for a few day to a spec. query can someone help me?

table A:
R1 R2 R3
a - 6 - z
d - 2 - p
a - 5 - y
g - 8 - w
d - 6 - w

I need:
R1 R2 R3
a - 6 - z
d - 6 - w
g - 8 - w

I 've allready try this query
Select R1,max(R2),R3 from a group by R1
R1 R2 R3
a - 6 - z
d - 6 - p ***THIS ISN'T CORRECT***
g - 8 - w

The problem with this query:
R1 - ok
R2 - ok
R3 - i'll get the first record the query see so this ain't the corresponding record

Can some one help me out?

Thx,

 

[JamesLean]

This exact same question has been answered in the SQL Server forum (although it was posted by a different person?)

See thread183-521291 --James