PDF download Download Article PDF download Download Article

This wikiHow teaches you how to use the ORDER BY clause in SQL to sort results from a table. The ORDER BY clause allows you to sort one or more columns in both ascending and descending order.

Alphabetical Order in SQL

Enter “Select,” then specify the table you want to order with “From [table_name}.” Then, enter “Order by [criteria].” If you don’t specify an order, your data will appear in alphabetical order (or you can enter “ASC”). To pull data in reverse alphabetical order, use “DESC” (for example, “Order by Name Desc”).

  1. This means we'll be looking at all columns. Move to the next line.
  2. Replace table_name with the name of the table, and then move to the next line. [1]
    Advertisement
  3. 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.
  4. You will now see your SQL results in the appropriate order.
  5. Advertisement

Expert Q&A

Ask a Question
      Advertisement

      Tips

      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Name
      Please provide your name and last initial
      Thanks for submitting a tip for review!

      About This Article

      Thanks to all authors for creating a page that has been read 113,024 times.

      Is this article up to date?

      Advertisement