Adds an order by clause to the query.

orderBy calls are additive. To order by multiple columns, call orderBy multiple times.

The first argument is the expression to order by and the second is the order (asc or desc).

An order by clause in a delete query is only supported by some dialects like MySQL.

See SelectQueryBuilder.orderBy for more examples.

Examples

Delete 5 oldest items in a table:

await db
  .deleteFrom('pet')
  .orderBy('created_at')
  .limit(5)
  .execute()

The generated SQL (MySQL):

delete from `pet`
order by `created_at`
limit ?