Re: sql questions

[Thiemo Kellner <thiemo@xxxxxxxxxxxxxxxxxxxx>]

Zitat von hamann.w@xxxxxxxxxxx:

> a) I am running some select query
> select ... order by ....
> Now, I would like to preserver the ordering through further  
> processing by adding a sequence number
> Of course I can do:
> create temp sequence mseq;
> select xx.*, nextval('mseq') as ord from (select ... order by ....) xx;
> drop sequence mseq;
> Is there a simpler way (avoiding the create/drop parts)

Can't you just do the ordering at the end of the processing? Maybe you  
need to drag along the order by columns and just dump them at the very  
end if applicable.

----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.

Attachment: bintUfp4rQQlN.bin
Description: PGP Public Key