Skip to Content
avatar image
Former Member

query result is without column header

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 24, 2017 at 09:24 PM

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

    Add comment
    10|10000 characters needed characters exceeded