sort data in mySQL

Question

my table is

+-----------+--------+--------+
| Name      | Weight | Height |
+-----------+--------+--------+
| Amin      |     75 |    180 |
| Mahdi     |     90 |    190 |
| Moahammad |     75 |    175 |
| Ahmad     |     60 |    175 |
+-----------+--------+--------+

I want sort a table from bigger Height and if Height is equal print lower weight first. and the result like this

Mahdi 190 90
Amin 180 75
Ahmad 175 60
Mohammad 175 75

`SELECT * FROM table_name ORDER BY Height DESC, Weight;` – Rohit-Pandey Oct 22 '18 at 05:16 — Rohit-Pandey, Oct 22 '18 at 05:16
`ORDER BY Height DESC, Weight ASC` – deceze Oct 22 '18 at 05:17 — deceze, Oct 22 '18 at 05:17

score 0 · Accepted Answer · answered Oct 22 '18 at 05:16

0

Use height as descending order then weight in ascending order

select name, hieght, weight
from tablename
order by height desc, weight

answered Oct 22 '18 at 05:16

Fahmi

37,315
5
22
31

this is the correct answer and work for me tanx a lot – fariborz najafi Oct 22 '18 at 05:25
if it helped you please mark it as answer @fariborznajafi – Fahmi Oct 22 '18 at 05:25

sort data in mySQL

1 Answers1