Select query with GROUP condition thens order by alphanumeric

[Chu Soon Tan]

Dear All:

i googleing for a day but still not able to solve my problems.

I have a table which having 50k++ rows data. How can perform a select query with group by condition and then order by alphanumeric?

For example:
-----------
1asds
a23
a-12
abs
b2ww3asd
bbdhas
v21
8bd
b-12
812
a23
s34123
8bd
0123
8-3
-----------

i want query the data and show the output as below:

---------------
a-12
abs
a23
b-12
bbdhas
b2ww3asd
s34123
v21
0123
1asds
8-3
8bd
812
---------------


isn't possible to do that?


millions thank at advances....



Edited 4 time(s). Last edit at 12/05/2009 03:28PM by Chu Soon Tan.