I’ve been studying the documentation and searching this community for information about how to order the results of a select expression by a separate column.
My app has an action that writes a list of words that have been studied recently. That is done with a select expression. Today, I thought it might be good to sort the order of those words by the number of times they have been studied (another column).
I know how to use ORDERBY to get a list of keys. I also know how to use SORT to order the list of words alphabetically. But, neither of those is exactly what I want to do now. Is there a good way to make a list of words (a column that is not a key) that is sorted according to another column? If, for example, I use ORDERBY with SELECT to get a list of the keys in the right order, can I convert that list of keys into a list of the “words” in the rows identified by the keys?
By the way, the number of words picked up by my current SELECT expression varies and the list can be moderately long, so using INDEX doesn’t seem like a very practical solution for me.