Re: SQL and Order By Question

["Michael Ryan" <michaelrtr@xxxxxxxxx>]

Describe the sort needed to get a, c, d, b.

On 7/30/07, Ashish Kulkarni <kulkarni_ash1312@xxxxxxxxx> wrote:
> Hi
> I have a table, which i want to sort by value in Key,
> for example the table is as below
> Key   Desc
> a     This is A
> b     This is B
> c     This is C
> d     This is d
>
> I want to read the result set as
>
> a
> c
> d
> b
>
> How do i write this SQl statement, if i just do order
> by Key i can get it either a,b,c,d or d,c,b,a but not
> the way i want
> Any ideas
>
> Ashish
>
> A$HI$H
>
>
>
> ____________________________________________________________________________________
> Be a better Heartthrob. Get better relationship answers from someone who knows. Yahoo! Answers - Check it out.
> http://answers.yahoo.com/dir/?link=list&sid=396545433
> --
> This is the Java Programming on and around the iSeries / AS400 (JAVA400-L) mailing list
> To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.