AnsweredAssumed Answered

ExecuteSQL - Sorting by the count value

Question asked by xxx202xxx on Jun 23, 2017
Latest reply on Jun 23, 2017 by xxx202xxx

I am attempting to write an eSQL where I want to pull back the Asset# and the amount of Tickets this Asset# has.  That part is okay.  My problem I can't figure out is how to sort where the Asset# with the most tickets are at the top or perhaps just keep the list short say down to the top 20 assets.

 

Outcomes