Need max value 1

[lanm]

I have two colums, WPID and WNum. WPID is distinct, but WNum can be reapeated.
For instance, I could have WPID 1-10, and each value for WNum would be 55555. What I need to do is get the maximum value for WPID associated to WNum, in this case 10.....and spin through all the records this way.

I've tried (and other ways):
SELECT MAX(WPID) AS Expr1, [WNum]
FROM WP_General_Info
GROUP BY [WNum], WPID

...but it's not working.

 

[Juice05]

Try

SELECT WNum, MAX(WPID) AS Expr1
FROM WP_General_Info
GROUP BY WNum

 

[lanm]

Right on! Thanks Juice05! That was it!

 

[Juice05]

No problem. You had the right idea, just backwards.