A field is: not, 50%, 70%, 80%, 100% of these values, look it up by 100%, 80%, 70%, 50%, and no order

CodePudding user response:

The order by the replace (the name, the '%', ') + 0

CodePudding user response:

CodePudding user response:

Order by decode (riskLevel, 'no' - 99999, cast (replace (riskLevel, '%', ') as number)) desc

CodePudding user response: