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