Could some one help me with a requirement like this ?
Suppose my query is like this, which hits the database:
SELECT * from Schema.TableName;
Result (Alphabetically):
A
ALL
B
BALL
C
CAT
D
DOLL
E
EGG
Now my requirement is to get the reult in which 'ALL' should be at first, then rest of the values Alphabetically. Quite interesting gonna be. Please guide.