Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2012
    Posts
    4

    average of distinct values

    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.

  2. #2
    Join Date
    Jan 2009
    Location
    Ohio, United States
    Posts
    166
    Not sure if this is what you mean (see attachment)
    Attached Files Attached Files

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •