Dear Team

I am using the group by for getting top n number of record like below mentioned query

        (for $areaData in collection('mycollection')
         let $areaName := $areaData/Contry
          group by $areaName
         return $areaData )[position() lt 100]

In this case i am getting first top 100 records and then it is grouping on those records.Can you please suggest me how can we get the top 100 records based on the Country name

Please find the attachment for the sample data.Please do the need full on this/

Thanks&Regards

Chandra Sekhar

The information contained in this e-mail and any accompanying documents may contain information that is confidential or otherwise protected from disclosure. If you are not the intended recipient of this message, or if this message has been addressed to you in error, please immediately alert the sender by reply e-mail and then delete this message, including any attachments. Any dissemination, distribution or other use of the contents of this message by anyone other than the intended recipient is strictly prohibited.