Sort Value with specific values in First

[Shraddha]

Hello Saviynters,

I am trying below query expecting to have these values on top however its not happening. Tested in Data Analyzer 

1. Evercheck Administration Group (ADMIN)

2. Drive Administrator (Drive_Administrator)

select ev.ENTITLEMENT_VALUE from entitlement_values ev, entitlement_types et
where ev.ENTITLEMENTTYPEKEY = et.ENTITLEMENTTYPEKEY and
et.endpointkey = 450 ORDER BY CASE WHEN ev.ENTITLEMENT_VALUE = 'Evercheck Administration Group (ADMIN)' THEN 1
WHEN ev.ENTITLEMENT_VALUE = 'Drive Administrator (Drive_Administrator)' THEN 2
ELSE 3 END

Output I get normal list only , not these two values at top.

Any Solution?

Best Regards

Shraddha

[rushikeshvartak]

Please provide screenshots. Saviynt by default sort on first column of result

[Shraddha]

Not getting expected result with above mentioned query.  However everywhere its suggested , using case will sort values as per given index.   Kindly help me on how to manage this.

[rushikeshvartak]

Result is A-z which is expected , Share query in text format with expected result