K
K
Konstantin KOltin2020-06-25 15:07:11
MySQL
Konstantin KOltin, 2020-06-25 15:07:11

Sort request?

Good afternoon.

$query ="SELECT items.owner_id, characters.char_name, items.item_id, items.count FROM items INNER JOIN characters ON items.owner_id=characters.charid WHERE items.item_id=57;";

Tell me how to sort by the items.count column in this query to display the data in descending order?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
S
Stalker_RED, 2020-06-25
@Stalker_RED

... order by items.count desc

K
Konstantin KOLtin, 2020-06-28
@KOltin

I know how to apply it correctly.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question