How to Order Alphabetically in SQL

Enter SELECT *. This means we'll be looking at all columns. Move to the next line.WH.performance.mark('step1_rendered');

Enter SELECT *.

Enter FROM table_name. Replace table_name with the name of the table, and then move to the next line.[1] X Research source

Enter FROM table_name.

Enter ORDER BY criteria;. Here are some examples:For example, if you wanted to display results in alphabetical order based on a column called NAME, you'd use ORDER BY NAME;. Ascending order is the default sort order, but you could also specify that you want it ascending using ORDER BY NAME ASC; if you'd like.If you'd rather show the results in the opposite order, you'd use ORDER BY NAME DESC;. DESC means 'descending order.'If you want to sort based on two columns, separate them by commas. For example, ORDER BY LAST_NAME ASC, FIRST_NAME DESC; would display results sorted alphabetically by last name. If the same LAST_NAME matches multiple FIRST_NAME entries, the results of FIRST_NAME will also display in descending order.

Enter ORDER BY criteria;.

Execute the command. You will now see your SQL results in the appropriate order.

Execute the command.