lundi 10 août 2015

how to make complex ordering in sqlite?

I have table with fields priority, completed_time,completed. Completed colume have values 0 and 1 and it is a primary sort. I want to make secondary sort to be priority if completed is 0 and completed_time if completed is 1. How can i get it?
I know only how to make unconditional sort by two parameters like:

String orderBy = "completed ASC, priority DESC"

Aucun commentaire:

Enregistrer un commentaire