๋ชฉ๋กWeb/sql (1)
๐ฑ dreaming DiNO
[SQL] order by boolean column as true, null, false
SQL for sorting boolean column as true, null, false => 1๋ฒ ๋ฐฉ๋ฒ์ผ๋ก sorting @Query("SELECT * FROM $MISSING_TABLE_NAME ORDER BY (case when emergency then 1 else 2 end) asc") suspend fun getAll(): List Questions : SQL for sorting boolean column as true, null, false My table has three boolean fields: f1, f2, f3. If I do SELECT * FROM table ORDER BY f1, f2, f3 the records will be sorted by these fields i..
Web/sql
2022. 10. 5. 14:52