自定义顺序排序

来源：互联网发布：java ==是什么意思编辑：程序博客网时间：2024/05/17 08:01

--sql codecreate table tb( GSIZE varchar(10))insert into tb(GSIZE) values('M')insert into tb(GSIZE) values('L')insert into tb(GSIZE) values('S')insert into tb(GSIZE) values('XL')insert into tb(GSIZE) values('3XL')insert into tb(GSIZE) values('2XL')insert into tb(GSIZE) values('4XL')--size:关于物料的size,例如衣服,鞋之类的产品,如衣服size(按大到小排序应为):S,M,L,XL,2XL,3XL,4XL--我sql 查询时怎样做排序呢:不知道有没有如到这种问题呢?select * from tb order by GSIZEselect * from tborder by charindex(','+GSIZE+',',',S,M,L,XL,2XL,3XL,4XL,')select * from tb order by case when charindex('S',GSIZE)>0 then 1 when charindex('M',GSIZE)>0 then 2 when charindex('L',GSIZE)>0 then 3 end, len(GSIZE), GSIZE/**GSIZE ---------- SMLXL2XL3XL4XL（所影响的行数为 7 行）**/http://topic.csdn.net/u/20100111/17/ccc472de-0964-408f-bc49-93ce8aeb7597.html