'order by' - add a unique column as the last sort item

[Joe Boyle]

just one extra point on use of 'order by', if the data is going to be
displayed it's best to add a unique column as the last sort item. Otherwise
you will probably get random order within the last sort item, as I found to
my cost on one or two occasions :-)

Regards, Joe.

This e-mail and all information contained in it is confidential and may be
legally privileged. If you are not the intended recipient, your access to
this e-mail is unauthorized. Any use, dissemination, distribution,
publication or copying by you of this e-mail or any of the information
contained within it is prohibited and may be unlawful. Do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so. The content of this 
e-mail and any attachments sent with it may have been altered without the
consent or knowledge of the author.