Subject RE: [firebird-support] How To Display Null Values At the End For More Than One Columns Specified in Order By Clause?
Author Svein Erling Tysvær
>Table values are as you shown:
>
>MyTable
>FieldA FieldB FieldC
>1 2 3
>1 2 <null>
>1 <null> 2
>2 3 4
>2 <null> <null>
><null> 2 3

Is this how you want them, or is this how they are? Please show us

a) Your query (including the PLAN and definitions of the indexes used)
b) (Parts of) the result you get
c) The result you want

Set