How to SELECT FROM MySQL table in DESCENDING ORDER of a column?

SELECT FROM table in DESCENDING ORDER of a column

When you select rows from a table, you can select those based on the ascending and descending order of the

values in a column.

In this MySQL Tutorial, we shall learn how to select rows of a table based on the descending order of values in

a column.

To sort rows of a result set in descending order of values in a column, use the syntax of the following SQL

Query.

mysql> SELECT *

FROM table_name

ORDER BY

column_name DESC;

mysql> SELECT * FROM table_name ORDER BY column_name DESC;

The character set of the column is considered while sorting the column values in descending order.

Example to sort rows of a table in DESCENDING ORDER of a column¡¯s

values

Consider the following students table.

Now we shall sort these rows in DESCENDING ORDER of name column.

Run the following query to sort the records in descending order.

mysql> SELECT *

FROM students ORDER

BY name DESC;

mysql> SELECT * FROM students ORDER BY name DESC;

Learn MySQL

?

MySQL Tutorial

User Management

?

MySQL Server - Login to mysql Command Line Interface

?

MySQL Server - Get list of All Users

?

MySQL Server - Get list of Connected Users

DATABASE

?

MySQL - Create DATABASE

?

MySQL - Delete DATABASE

?

MySQL - Show existing Databases

?

MySQL - Select or Use DATABASE

TABLE

?

MySQL - Create Table

?

MySQL - Rename Table

?

MySQL - Duplicate a Table

?

MySQL - Add a new Column to Table

?

MySQL - Delete or Drop a Column from MySQL Table

?

MySQL - Select Distinct Values of Column

?

MySQL - Count number of rows in Table

?

MySQL - Increase column size

?

MySQL - Add an AUTO_INCREMENT column as PRIMARY KEY

?

MySQL - Add Column to INDEX

?

MySQL - Delete or Drop Column from INDEX

?

MySQL - SHOW INDEX of Table

?

MySQL - Rename Column or Change Column

Solve Issues

?

MySQL - LAST_INSERT_ID returns 0

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download