表中key列,数据如下:
如何实现如下输出效果:
建表语句:
CREATE TABLE order1 (
key varchar(255)
);
INSERT INTO order1 VALUES ('A');
INSERT INTO order1 VALUES ('B');
INSERT INTO order1 VALUES ('C');
INSERT INTO order1 VALUES ('D');
查询SQL:
select key from order1
order by
case key
when 'B' then 1
when 'A' then 2
when 'D' then 3
when 'C' then 4
else null end;