I am using the
concat() function in the
SELECT statement, but it is including the same column twice in the output.
SELECT firstname, surname, concat(firstname,' ',surname) AS fullname FROM employee
| firstname | surname | | John | Kenedy |
| firstname | surname | fullname | | John | Kenedy | John Kenedy |
Is my usage of