'Incorrect display of column names in singleton query teradata

I am building a singleton query, which is supposed to return predefined data from the query. The idea is that Name, Company, Department are column names.

WITH
singleton AS 
(
   SELECT  1 AS x
)
(
   SELECT  'Name','Company','Department' FROM singleton UNION
   SELECT 'A','b','c' FROM singleton UNION
   SELECT 'D','e','f' FROM singleton
)

However, the following issues occur:

  • The column names are with a ' in front and in the back.
  • The column names are repeated as values (and I do not want them)

enter image description here



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source