Possible to sort additional Fields by ASC DSC

There is way where you can use both orders ASC | DESC, If you are using to sort the records based on two column, As sometime we need to show data in order of first column and then by second column. you can do that by using below example. In this SQL query is performed on Customer_Name and Product_Category to do the sort DESC and ASC respectively  Macys My Insite