how to to select concatenated ''city'' and ''state'' columns, represented with a new custom column named ''new_address''.

Question

how to select concatenated ''city'' and ''state'' columns, represented with a new custom column named ''new_address''.

Answer 1

select concat(city,state) as new_adress from some_table

Answer 2

SELECT CONCAT (city, ', ', state)
AS new_address
FROM customers;

Answer 3

SELECT CONCAT (city, ', ', state)
AS new_address
FROM customers;

Answer 4

select concat(city,state) as new_adress from some_table

Answer 5

Thank You 1of3

Answer 6

SELECT CONCAT (city, ', ', state)
AS new_address
FROM customers;