--- In firebird-support@yahoogroups.com, Gabor Boros <gaborboros@...> wrote:
>
> Hi,
>
> You can define NULLs placement by column.
> In example:
> ORDER BY 2 NULLS LAST, 1 NULLS LAST, 3 NULLS LAST
>
> http://www.firebirdsql.org/refdocs/langrefupd21-select.html#langrefupd21-tbl-null-placement
>
> Gabor
>
> jasajona írta:
> > Hello,
> >
> > If there is: ORDER BY 2 NULLS LAST
> > Everything is fine all records with second field value NULL go to bottom.
> >
> > If there is: ORDER BY 2, 1, 3 NULLS LAST
> > Even if all first three fields are null record go to top.
> >
> > Should I report a bug or there is something else that I do not know?
> >
> > Thank you!
>