Shulou(Shulou.com)05/31 Report--

Most people don't understand the knowledge points of this article "how to use ORDER BY statement in mysql", so Xiaobian summarizes the following contents for everyone. The contents are detailed, the steps are clear, and they have certain reference value. I hope everyone can gain something after reading this article. Let's take a look at this article "how to use ORDER BY statement in mysql".

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; The above is about "how to use ORDER BY statement in mysql" this article content, I believe everyone has a certain understanding, hope the content shared by Xiaobian is helpful to everyone, if you want to know more related knowledge content, please pay attention to the industry information channel.

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.