Sorting by Column Number
SELECT product_name, category FROM products ORDER BY 1;
This retrieves the product name and category from the products table and sort the first selected column which is product_name.
Output:
ORDER BY Clause
ORDER BY Statement in MariaDB
In MariaDB, the ORDER BY clause is an important component for organizing the result set of a query in a certain order. Being aware of the complexities of ORDER BY can significantly improve your capacity to get and evaluate data effectively, regardless of whether you’re working with one or more columns, ascending or descending sorting, or both. This article will explore the ORDER BY statement in MariaDB, including its syntax, uses, and best practices.