SELECT *
FROM tbl_test
ORDER BY "@#$$%#$%@$@#$@$@#@$这里应该咋写?"
两个表联合查肯定没问题,现在就是想如果单独用这个表的话。咋弄。多谢啦!!!!
...全文
102410打赏收藏
如何让ORDER BY 按指定的顺序排序?
表里有个列叫Type,是商品类别,就3种情况:S,A,B。现在我需要按照SAB的顺序排序,那位大侠能帮帮忙啊, SELECT * FROM tbl_test ORDER BY "@#$$%#$%@$@#$@$@#@$这里应该咋写?" 两个表联合查肯定没问题,现在就是想如果单独用这个表的话。咋弄。多谢啦!!!!
SELECT *
FROM tbl_test
ORDER BY "@#$$%#$%@$@#$@$@#@$这里应该咋写?"
----------------------------------------------
换个方法
select * from table where type='S' union all
select * from table where type='A' union all
select * from table where type='B'