How to sort from newest to oldest?

T

thekot242016-08-28 22:50:36

SQL

thekot24, 2016-08-28 22:50:36

With a database query:

SELECT * FROM `messages` ORDER BY `id` DESC LIMIT 50

I receive messages, BUT new ones are on top, and old ones are on the bottom. How to do the opposite? If you remove DESC - there will be a current of the first 50 ...

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

D

dev400, 2016-08-28
@thekot24

asc

Similar questions

T

twittoponchik2022-01-07 12:30:00

Can I withdraw money from AdSense to my IP if the application is posted on Google Play on behalf of an LLC? 5Reply

S

Sanzhar Bazarbek2021-04-04 12:35:40

How to remove blur from an image? 2Reply

I

IlyaPrivolnov3332022-02-16 13:24:32

How to add an amount from another table to an empty column of a table according to a given condition? 4Reply

Z

Zhangirkhan Nurgaliev2016-03-18 14:14:34

Translate procedures and functions from oracle sql to ms sql. How? 1Reply

S

SoloMidPlzD2016-03-20 00:49:16

MySQL many-to-many => nosql? 3Reply

Didn't find what you were looking for?

Ask your question