SQL CONCATENATE: This clause combine together (concatenate) the results from several different fields.
Syntax:
CONCAT(str1, str2, str3, ...):
CONCAT(str1, str2, str3, ...):
Example:
SELECT CONCAT(first_name, last_name) FROM employee WHERE salary > 1000
SELECT CONCAT(first_name, last_name) FROM employee WHERE salary > 1000
0 Comments:
Post a Comment