Cross Join
SELECT * FROM [TABLE 1], [TABLE 2]
Každý řádek s každým
SELECT LastName, FirstName, COALESCE(HomePhone,
Extension) AS PhoneNumber FROM Employees
SELECT LOWER('THis is sOME TEXT')
SELECT UPPER('THis is sOME TEXT')
SELECT CONCAT('This i', 's some text', '.')
SELECT LENGTH('This is some text')
SELECT TRIM('ab' FROM 'ababzzzzab')
==> zzzz
SELECT TRIM(' a string message ')
==> a string message
SELECT SUBSTRING('abcd', 1, 2)
==> ab