'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)
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|

