SQL CONCATENATE - Introduction and syntax

Explain the SQL CONCATENATE statement. Write SQL syntax for the SQL CONCATENATE statement along with an example.

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