[SQL ] 多個欄位排序

看板Database作者wzbird (大鳥)時間14年前 (2011/10/31 15:15)推噓0(0推 0噓 4→)

留言4則, 2人參與討論串1/2 (看更多)

hi, 大家好我用的DBMS是sqlite 我有一個table是這樣 ID TEST1 TEST2 TEST3 TEST4 1 PASS PASS FAIL PASS 2 PASS PASS PASS PASS 3 FAIL PASS PASS PASS 4 PASS PASS PASS PASS 5 PASS PASS PASS FAIL 6 PASS PASS PASS PASS 有沒有sql command可以作到, 有FAIL的行排在前面這樣呢？以上表為例, 結果就是 ID TEST1 TEST2 TEST3 TEST4 1 PASS PASS FAIL PASS 3 FAIL PASS PASS PASS 5 PASS PASS PASS FAIL 2 PASS PASS PASS PASS 4 PASS PASS PASS PASS 6 PASS PASS PASS PASS 謝謝大家 -- ※ 發信站: 批踢踢實業坊(ptt.cc) ◆ From: 122.147.144.114

→

glennchen

10/31 15:48, , 1^F

10/31 15:48, 1^F

→

glennchen

11/02 01:21, , 2^F

11/02 01:21, 2^F

→

wzbird

11/02 01:58, , 3^F

11/02 01:58, 3^F