nodiaque Posted April 4, 2014 Report post Posted April 4, 2014 Hello everyone, I have a query that I'm unable to make. Here's the situation. I have a collection which contain x number of computer (let's say 200). I want a query that return the top x computer from the list (let's say 33% of it or top 50 computers) and put them into a collection. The idea is to have a way to distribute update to specific computers based on there name order (like serial number), but I want it to be dynamic and always have the same ratio (33% or a top 50, something like that). In SQL, I would use "select top (33) PERCENT", but I can't find the equivalent in WQL. Thank you! Quote Share this post Link to post Share on other sites More sharing options...
Peter van der Woude Posted April 4, 2014 Report post Posted April 4, 2014 Select TOP does not exist in WQL and there is not really an alternative... You have to find something else to filter on Quote Share this post Link to post Share on other sites More sharing options...
