關(guān)于string類型只能轉(zhuǎn)換為double數(shù)字類型進(jìn)行排序
case1:
select cast(num as double) as num1
? from (
? ? ? ? select DISTINCT regexp_replace(categories,'\[|\]','') as num
? ? ? ? ? from table_name
? ? ? ? WHERE dt=20180115
? ? ? ? ? and categories is not null
? ? ? )
ORDER BY num1
