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