2 Replies Latest reply on Jun 23, 2017 7:53 AM by xxx202xxx

    ExecuteSQL - Sorting by the count value


      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.