O'Reilly logo
  • Wiktor Bojanowski thinks this is interesting:

Expression

ColumnOne || ColumnTwo

From

Cover of SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, Fourth edition

Note

MySQL example:

SELECT CONCAT(BowlerFirstName, " ", BowlerLastName) AS BowlerFullName FROM Bowlers;