But here I am getting one extra column which I don't want.

and also in other cases I need to use multiple case statement with order by because different datatype of columns create problem in single case statement with multiple whens.

Plz provide solution to this prob