On 8/30/2011 2:03 PM, Markus Ostenried wrote:

>
> On Tue, Aug 30, 2011 at 10:20, Vander Clock Stephane
> <svanderclock@... <mailto:svanderclock%40yahoo.fr>> wrote:
> > Hello,
> >
> > how to put the num value at the end of the result (and not at the
> > beginning) when we are doing
> >
> > select xxx order by xxx ASC
>
> Howdy,
> maybe this helps:
>
> select xxx from tbl order by xxx asc NULLS FIRST
>
> Bye,
> Markus
>
>

I think he wants the Nulls at the end so: select xxx order by xxx ASC
NULLS LAST

--
Thanks,

Gordon



[Non-text portions of this message have been removed]