0

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

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

21st Nov 2017, 7:21 PM
Kumar Abhinav Jha
Kumar Abhinav Jha - avatar
6 odpowiedzi
+ 4
select concat(city,state) as new_adress from some_table
21st Nov 2017, 7:26 PM
1of3
1of3 - avatar
+ 1
SELECT CONCAT (city, ', ', state) AS new_address FROM customers;
7th Apr 2018, 4:57 PM
Mahnoor Shahzad
Mahnoor Shahzad - avatar
+ 1
SELECT CONCAT (city, ', ', state) AS new_address FROM customers;
14th Jan 2020, 6:47 AM
Prakash Singh
Prakash Singh - avatar
+ 1
select concat(city,state) as new_adress from some_table
4th Jul 2020, 8:52 PM
Faith Mundi
Faith Mundi - avatar
+ 1
Thank You 1of3
4th Jul 2020, 8:53 PM
Faith Mundi
Faith Mundi - avatar
+ 1
SELECT CONCAT (city, ', ', state) AS new_address FROM customers;
10th Sep 2020, 8:57 PM
Anuradha Sathiyachalam
Anuradha Sathiyachalam - avatar