SQL search for the minimum values ​​related to a duplicate table

advertisements

I have a SQL View that pumps out the following table, two columns

Column 1   Column 2
ID         Value
1          10
1          12
1          15
2          3
2          6

I'd like to search for where record 1 returns it's minimum value (10) and record 2 returns it's minimum value (3)

Any help greatly appreciated.


SELECT
    id
  , MIN(value)
FROM yourview
GROUP BY id