SQL CONCATENATE

SQL CONCATENATE: This clause combine together (concatenate) the results from several different fields.
Syntax:CONCAT(str1, str2, str3, ...):

Example:SELECT CONCAT(first_name, last_name) FROM employee WHERE salary > 1000

---