hi users
i have a requirement
i have values in a column
yamunesh
yamunesh
yamunesh
yamunesh
yamunesh
yamunesh
yamunesh
yamunesh
yamunesh
yamunesh
babu
babu
babu
babu
babu
babu
babu
babu
babu
babu
babu
babu
babu
babu
babu
babu
babu
babu
babu
babu
lingam
lingam
lingam
lingam
lingam
lingam
lingam
lingam
lingam
lingam
lingam
lingam
lingam
lingam
lingam
i want to retreive the 10% of distinct values..
for examples
yamunesh is a name having 10 times.
i need it 10 %
means 1 time it should appear..
please tell me the code or the logic to find the values..
thanks in advance.