1 Reply Latest reply on Dec 16, 2014 7:28 AM by Steven Hawkins

    Alias column name is not available in the resultset for MIN and MAX functions

    Rakesh Balguri Expert

      Hi all,

       

      I have a SQL of the form select MAX(AGE) AS "MINAGE", MIN(AGE) AS "MINAGE" FROM EMPLOYEE.

      When I try to execute the sqql in Squirrel, the column names in the result always display the alias name as the column name instead of the Alias Name given in the SQL.

       

      Do we have a solution to get the Alias Column or is this a bug?

       

      Thanks

      Rakesh