hi, Im using oracle,

Id like to have the repeated columns

example:

Code:
id           value
1              5
2              5
3              8
4              9
5              3
6              8
Id like to have this result:
Code:
value
5
8
any help?
thanks