|
gsrinivas.
Yak Posting Veteran
53 Posts |
 Posted - 10/26/2012 : 14:05:42
|
Hi team,
I have an issue with order by clause..
plz suggest me the best query..
Thanks in advance...
-Srinivas.
-----------************************************--------------
INPUT
-----------************************************--------------
CREATE TABLE T ( C1 VARCHAR(20),C2 VARCHAR(20))
INSERT INTO T VALUES ('ALFABET','A')
INSERT INTO T VALUES ('ALFABET','B')
INSERT INTO T VALUES ('ALFABET','C')
INSERT INTO T VALUES ('NUBER','1')
INSERT INTO T VALUES ('NUBER','2')
INSERT INTO T VALUES ('NUBER','3')
INSERT INTO T VALUES ('NUBER','4')
INSERT INTO T VALUES ('SYMBOL','+')
INSERT INTO T VALUES ('SYMBOL','-')
-----------************************************--------------
OUTPUT
-----------************************************--------------
Now the output should be as follows...
NUBER 1
NUBER 2
NUBER 3
NUBER 4
ALFABET A
ALFABET B
ALFABET C
SYMBOL +
SYMBOL - |
|
|
robvolk
Most Valuable Yak
USA
15557 Posts |
Posted - 10/26/2012 : 14:14:22
|
SELECT * FROM T
ORDER BY CASE WHEN C2 LIKE '%[0-9]' THEN 0 ELSE 1 END,
CASE WHEN C2 LIKE '%[A-Z]' THEN 0 ELSE 1 END,
CASE WHEN C2 LIKE '%[^0-9A-Z]' THEN 0 ELSE 1 END,
C2 |
 |
|
An "order by" issue..
