9.6. SQL Select From

9.6.1. Rationale

../../_images/sql-select.png

9.6.2. All Columns

SELECT * FROM astronauts;

9.6.3. Selected Columns

SELECT firstname, lastname
FROM astronauts;

9.6.4. Column Name Aliases

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