→ glennchen:有個爛方法就是用union 10/31 15:48
→ glennchen:union錯了嗎 11/02 01:21
→ wzbird:union應該可以~我這兩天一直在想樓下大大的IF方法怎麼寫 11/02 01:58
→ wzbird:我研究不出來的話大概要用union了 感謝你的分享^^ 11/02 02:00
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