default sorting with ORDER BY puts the NULL values at the beginning.
How can I change this behaviour? I.e., instead of

a       b
-----   ----
x      NULL
y      0
z      2

I would like to have

a      b
----    ----
y      0
z      2
x      NULL

Explanation: I have a table with e-values (expected number of
something). A lower e-value means a more significant search hit. No
evalue at all means that hit was not found, so that the missing
e-values should be reported at the end (unfortunately, I want to have
them reported, but just not at the beginning).

Thank you in advance,


---------Dr. January Weiner 3  -----------------+-------------------
Inst. of Bioinformatics, UKM, Univ. of Muenster | Von-Esmarch-str. 54
(+49) (251) 83 53002                            | D48149 M√ľnster
http://www.compgen.uni-muenster.de/             | Germany
sqlite-users mailing list

Reply via email to