| Subject | Re: Re: [firebird-support] How To Display Null Values At the End For More Than One Columns Specified in Order By Clause? |
|---|---|
| Author | liviuslivius |
| Post date | 2015-03-12T13:21:05Z |
Hi,
do you really do sort in this way?
SELECT
FieldA, FieldB, FieldC
FROM
MyTable
ORDER BY FieldA NULLS LAST, FieldB NULLS LAST, FieldC NULLS LAST
regards,
Karol Bieniaszewski
W dniu 2015-03-12 14:05:10 użytkownik Vishal Tiwari vishualsoft@... [firebird-support] <firebird-support@yahoogroups.com> napisał:
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 3On Thursday, 12 March 2015 6:32 PM, Vishal Tiwari <vishualsoft@...> wrote: