Concat" in select formula, Snowflake

Programming
, ,
1

Revised:
I am using the concat() function in the SELECT statement, but it is including the same column twice in the output.

Example:

SELECT
firstname,
surname,
concat(firstname,' ',surname) AS fullname
FROM
employee

Source data:

| firstname | surname |
| John      | Kenedy  |

Expected Output:

| firstname | surname | fullname |
| John      | Kenedy  | John Kenedy |

Is my usage of concat() incorrect?

2

No, your usage of concat() is correct. The issue is that you included the same column (firstname and surname) in both the select list and the concat() function. To fix this, simply remove firstname and surname from the select list:

SELECT
concat(firstname,' ',surname) AS fullname
FROM
employee

This will give you the expected output:

| fullname      |
| John Kenedy   |