8.6. SQL Select From

8.6.1. Rationale

../_images/sql-select.png

8.6.2. All Columns

SELECT * FROM astronauts;

8.6.3. Selected Columns

SELECT firstname, lastname
FROM astronauts;

8.6.4. Column Name Aliases

SELECT firstname AS fname,
       lastname AS lname
FROM astronauts;
SELECT firstname,
       lastname,
       previous_job as career
FROM astronauts;