Re: [sqlite] ORDER BY and NULL values

"January Weiner" wrote in message news:454237550904191253i7b56d4b3qb649ec7815217...@mail.gmail.com > default sorting with ORDER BY puts the NULL values at the beginning. > How can I change this behaviour? select * from myTable order by (b is null), b; Igor Tandetnik

Re: [sqlite] ORDER BY and NULL values

select * from MyTable order by case when b is null then 0 else 1 end, b On Sun, Apr 19, 2009 at 3:53 PM, January Weiner wrote: > Hello, > > default sorting with ORDER BY puts the NULL values at the beginning. > How can I change this behaviour? I.e., instead of > > a