Using '.mode column" in conjunction with ".headers on" you're already using makes it a lot more obvious.
On Mon, Dec 24, 2018, 12:20 PM Luuk <luu...@gmail.com wrote: > On 24-12-2018 19:21, Peter Johnson wrote: > > The headers are present in all three queries you pasted. > > > > The first result shows two rows, the top row is the header. > > > > The other two results show 4 rows each, the top row of each is the header > > row. > > > > -P > > > > On Tue, 25 Dec 2018, 3:42 AM Luuk <luu...@gmail.com wrote: > > > >> sqlite> .version > >> SQLite 3.26.0 > >> > >> sqlite> .headers on > >> > >> sqlite> select 1 as X,date(); > >> X|date() > >> 1|2018-12-24 > >> sqlite> select x,row_number() over (order by 1 desc) from (select 1 as x > >> union all select 2 union all select 3); > >> x|row_number() over (order by 1 desc) > >> 3|1 > >> 2|2 > >> 1|3 > >> > >> Why are the headers missing in above query? > >> > > > Why was i overlooking this? > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users