Is there a good solution to sorting using two columns? For example.
Table Before
| A header | Col 1 | Col 3 |
|---|---|---|
| First | a | |
| Second | c | |
| Third | b |
So the result is
| A header | Col 1 | Col 3 |
|---|---|---|
| First | a | |
| Third | b | |
| Second | c |
I was thinking about using UNION but we can’t use it. Thanks!