View previous topic :: View next topic
|
Author |
Message |
sivatechdrive
Active User
Joined: 17 Oct 2004 Posts: 191 Location: hyderabad
|
|
|
|
Hi
This Query was asked in an interview
In a Column the Data is as below
EMPNO
====
12ABC
AB12C
A1B2C
1234A
B1234
D564F
45F89
The Output from the Table Should be like below
EMPNO
====
12ABC
12ABC
12ABC
1234A
1234C
564DF
4589F
There is no order in arangement of data
How can the query be to arrange the output such that the numeric comes first
Cheers..Prasad |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
I suspect you will not do this with a simple query. . . . |
|
Back to top |
|
|
|