I am trying to figure out if there can be more than two ORDER BY's in a single query, instead of having multiple queries. For some reason every time I include a third 'ORDER BY' it does not work on any column I choose.
Here is my code (Single Query For Each):
This is what I am trying to do (This includes a Customer Order By):
Any help would be highly appreciated! Thank you !
ORDER BY CASE WHEN .... END ASC, Col1,Col2 ....
Separate multiple columns by comma instead of adding
ORDER BY for each column