MYSQL is sorted in ascending order, but the value is 0 at the end. mysql is sorted in ascending order.

MYSQL is sorted in ascending order, but the value is 0 at the end. mysql is sorted in ascending order.

Reproduced http://blog.csdn.net/looksun/article/details/51445205

For example, the data in a table is as follows:

Sort in ascending order according to the value of the gz column, but the value of 0 is placed at the end, that is, the final result is as follows:

The specific implementation method is as follows:

1. Order BY expression

SELECT nian, gz from Tbl order by gz! = 0 desc, gz

2. Arithmetic

SELECT nian, gz, 1/gz as od from Tbl order by od desc