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? > > > > sqlite> select x,row_number() over (order by 1 desc) as Y from (select 1 > as x union all select 2 union all select 3); > x|Y > 3|1 > 2|2 > 1|3 > sqlite> > > _______________________________________________ > 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