Perform a select statement to get lower values by id

[nexusbr]

Hi,

supposedly i have this table:

ID   Value
1     22
1     17
2     14
2     01
2     55
3     20
4     36
4     40
4     51
4     38

and i want to select those records only:

ID   Value
1     17
2     01
3     20
4     36

which means that i need the lowest values by id..

seems to be easy enough to accomplish, but i've gotten myself stuck on it...

thanks for any help

[ck9663]

will a...

SELECT ID, MIN(Value) from YourTable Group by ID

work?

Happy Coding!!!

~~ CK