I have indexed a table which is giving me result like following
A
B
C
D
E
F
H
H
A
B
I want to sort result in such a manner that I get H first everytime and then rest should be sort by asc like
H
H
A
A
B
B
C
D
so on...
I am not finding a way for this. Please help.