Syntax error How to change order of items in MySQL?

How to change order of items in MySQL?

To change order of items in MySQL, use ORDER BY alias name. Let us first create a table −

mysql> create table DemoTable653 (Product1Amount int,Product2Amount int);
Query OK, 0 rows affected (0.42 sec)

Insert some records in the table using insert command −

mysql> insert into DemoTable653 values(400,250);
Query OK, 1 row affected (0.14 sec)
mysql> insert into DemoTable653 values(500,300);
Query OK, 1 row affected (0.16 sec)
mysql> insert into DemoTable653 values(40,400);
Query OK, 1 row affected (0.15 sec)
mysql> insert into DemoTable653 values(200,450);
Query OK, 1 row affected (0.14 sec)
mysql> insert into DemoTable653 values(50,20);
Query OK, 1 row affected (0.10 sec)

Display all records from the table using select statement −

mysql> select *from DemoTable653;

This will produce the following output −

+----------------+----------------+
| Product1Amount | Product2Amount |
+----------------+----------------+
|            400 |            250 |
|            500 |            300 |
|            40  |            400 |
|            200 |            450 |
|            50  |             20 |
+----------------+----------------+
5 rows in set (0.00 sec)

Following is the query to change the order of items and display the difference −

mysql> select Product1Amount,Product2Amount,(Product1Amount-Product2Amount) as ProductAmountDifference from DemoTable653 order by ProductAmountDifference;

This will produce the following output −

+----------------+----------------+-------------------------+
| Product1Amount | Product2Amount | ProductAmountDifference |
+----------------+----------------+-------------------------+
| 40             |            400 |                    -360 |
| 200            |            450 |                    -250 |
| 50             |             20 |                      30 |
| 400            |            250 |                     150 |
| 500            |            300 |                     200 |
+----------------+----------------+-------------------------+
5 rows in set (0.29 sec)
Updated on: 2019-08-23T11:39:37+05:30

472 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements