목록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