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