衣服尺码自定义排序sql

10月15日 13:51:1142雨林集团军阅读数 341

转载请注明出处

select SizeCup as Size ,OrderQty from

VW_CM1_SizeBreakdowm where So_NO =@So_No and so_item=@Item_No

order by

(case when SizeCup='XXXL' then '0'

when SizeCup ='XXS' then '1'

when SizeCup ='XS' then '2'

when SizeCup='S' then '3'

when SizeCup='M' then '4'

when SizeCup='L' then '5'

when SizeCup='XL' then '6'

when SizeCup='XXL' then '7'

when SizeCup='XXXL' then '8'

--else COMPARE_FLAG

end) ASC