Can we use AS keyword at the end of the query like this: SELECT CONCAT(FirstName, LastName) FROM Employees AS Name;

Question

I am getting confused, where to put the AS keyword, at the end or before the FROM.

Answer 1

AS should be positioned after each "column" variable, as it is a shortcut of ALIAS.

SELECT CONCAT(First name, LastName) AS Name FROM Employees;

In most SQL versions it even can be omitted, so you can just write:

SELECT CONCAT(First name, LastName) Name FROM Employees;

Answer 2

Thanks for the help. :)