ORDER BY functionality for two column data sorting #14819
Unanswered
stellarfinn
asked this question in
Help
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
I can't see a way to accomplish this so I was wondering if anyone had any ideas?
I have a products database. I want to sort by two columns, ItemCode and Category.
Ideally, it would sort by Category Ascending, and then Item Code Ascending. So you end up with products that belong in the same category together, and ordered by Item Code.
Currently, I'm just sorting by Item Code like below.
Sorting by Category groups them together but then the Item Codes are out of order.
Thoughts?
Beta Was this translation helpful? Give feedback.
All reactions