var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Need help in sql statement for Order by
I am new to oracle.
I have data in my table:
Now when I execute this statement
SELECT distinct col1 FROM mytable order by col1
its shows A,AA,B,C,D,E,FS where as I require in the order of AA,A,B,C,D,E,FS
while I tried with this
SELECT distinct col1 FROM mytable order by LEN(col1) DESC, col1 ASC
but i'm getting as AA,FS,A,B,C,D
Please help me out..
thanks & regards,
This is the SQL Server forum. Better repost in the right forum.
With kind regards . . . . . SQL Server 2000/2005/2012
Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages