The concatenation operator will concatenate columns or character strings to other columns. Represented by two vertical bars (||).
For example,
SELECT lastname||jobcode as "Employees" FROM tblEmployee;
It will result as
Employees
xyz_VP
abc_PRES
pqr_VP
No comments:
Post a Comment