topic Re: query result is without column header in Application Development and Automation Discussions

query result is without column header

Former Member — Wed, 24 May 2017 20:31:22 GMT

My query is working fine but result is coming without column header and if I export this to Excel this column is omitted, does anyone know how to sort it??

Re: query result is without column header

pokrakam — Wed, 24 May 2017 21:24:22 GMT

That's because the column is a result of a function and doesn't have a name. Not 100% sure if it will appear in your output, but you can give columns an alias with AS. Worth a try.

SELECT col1, col2, sum(col3) AS total, col4 ...

Re: query result is without column header

vg_sap — Wed, 24 Mar 2021 18:25:50 GMT

It doesn't work ;-/