order by descending?

[Sejmou]

Hi,

sorry if that is a dumb question, but I just can't can't figure it out: how can I control whether sorting within orderBy() should be done in ascending or descending order? It looks like I can only pass a list of column names.

Thanks in advance for your help.

Best regards,
Samo

[mattiaz9]

It's easier than you think:

await db.select().from(users).orderBy(asc(users.name), desc(users.createdAt));

[Sejmou]

Oh, wow, that is indeed very easy :)

Thanks for the quick response!