Write a query to get the first_name, middle_name and last_name in a single column as “name”. The first name, middle_name and the last name must be separated with space.
SELECT CONCAT(first_name, ' ', middle_name, '', last_name) as name FROM `customers`;
BY Best Interview Question ON 20 Sep 2022