Skip to Content
0

query result is without column header

May 24, 2017 at 08:31 PM

24

avatar image
Former Member

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??

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Mike Pokraka May 24, 2017 at 09:24 PM
0

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 ...

Share
10 |10000 characters needed characters left characters exceeded