Shulou(Shulou.com)06/03 Report--

This article mainly explains "the usage of ORDER BY statement in mysql". The explanation content in this article is simple and clear, easy to learn and understand. Please follow the idea of Xiaobian slowly and deeply to study and learn "the usage of ORDER BY statement in mysql" together.

Any field can be specified as a sorting condition.

2. Multiple fields can be specified as sorting conditions.

You can specify whether ASC or DESC keywords set the result set in ascending or descending order.

4. Follow at the end of SQL statement.

By default the ORDER BY statement is sorted in ascending order, i.e. ASC is executed.

examples

SELECT contactLastname, contactFirstname3FROM customersORDER BY contactLastname; Thank you for reading, the above is the "mysql ORDER BY statement usage" content, after the study of this article, I believe you have a deeper understanding of mysql ORDER BY statement usage, the specific use of the situation also needs to be verified. Here is, Xiaobian will push more articles related to knowledge points for everyone, welcome to pay attention!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.