Victoria Becu

Use single-row functions in query

Concatenating from people, converting all characters to upper or lowercase, etc.

• December 17, 2016 at 3:48 PM
• Visible to public

SELECT CONCAT(first_name, CONCAT(' ', surname)) AS name, born AS DOB
FROM people

SELECT title AS long_title, LENGTH(title) AS title_length
FROM movies
WHERE title_length > 20

SELECT UPPER(first_name)
from people

SELECT LOWER(surname)
FROM people