MySQL: CONCAT()
SELECT CONCAT(a,b) from table;
Oracle: CONCAT(), ||
SELECT a|| ' ' || b from table;
SQL Server: +
SELECT a+ ' ' + b from table;
SELECT CONCAT(a,b) from table;
Oracle: CONCAT(), ||
SELECT a|| ' ' || b from table;
SQL Server: +
SELECT a+ ' ' + b from table;