All for Joomla All for Webmasters

SQL SORTING ON MULTIPLE COLUMNS

Let’s take an example of customer table which has many columns, the following SQL statement selects all customers from the table named “customer”, stored by the “country” and “Customer-Name” columns:

  1. SELECT * FROM customers
  2. ORDER BY country, Customer-Name;
PinIt
submit to reddit

Leave a Reply

Top