作者wzbird (大鸟)
看板Database
标题[SQL ] 多个栏位排序
时间Mon Oct 31 15:15:52 2011
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
1F：→ glennchen:有个烂方法就是用union 10/31 15:48
2F：→ glennchen:union错了吗 11/02 01:21
3F：→ wzbird:union应该可以~我这两天一直在想楼下大大的IF方法怎麽写 11/02 01:58
4F：→ wzbird:我研究不出来的话大概要用union了 感谢你的分享^^ 11/02 02:00