CODEWITHSUNDEEP
mysqlsqlsql-order-by
brian
brian

Reputation: 2775

Is specifying `asc` on an order by in MySQL unnecessary?

My understanding is that

select ... order by column;

and

select ... order by column asc;

are functionally equivalent.

Is there any situation in which it would be required to use asc?

Upvotes: 0

Views: 204

Answers (1)

Saleem Ahmed
Saleem Ahmed

Reputation: 2999

MYSQL order by statement takes asc by default. if you want in descending order should specify desc

Upvotes: 2

Related Questions