Renaming Columns

Renaming Columns

---

SELECT <column> AS "<new name>";

-- Example
SELECT emp_no AS "Employee No.",
birth_date AS "Birthday",
first_name AS "First name"
FROM employees;

 Employee No. |  Birthday  | First name
--------------+------------+------------
        10001 | 1953-09-02 | Georgi
        10002 | 1964-06-02 | Bezalel
        10003 | 1959-12-03 | Parto
        10004 | 1954-05-01 | Chirstian
        10005 | 1955-01-21 | Kyoichi

Column Concatenation

---

CONCAT(string1, string2, ...., string_n)

--Example
SELECT emp_no, CONCAT(first_name, ' ', last_name) AS "full name"
FROM employees;

 emp_no |     full name
--------+-------------------
  10001 | Georgi Facello
  10002 | Bezalel Simmel
  10003 | Parto Bamford
  10004 | Chirstian Koblick
  10005 | Kyoichi Maliniak