1 reply

order by case clause possible?

can i model this in drizzle?

order by case when date >= today then date else null end asc, case when date < today then date else null end desc

order by case when date >= today then date else null end asc, case when date < today then date else null end desc

or should i just use

sql

sql

order by case clause possible? - Drizzle Team