AdvancedBasic SELECT

Create table using AS (CTAS)

The query

SQL

CREATE TABLE high_earners AS
SELECT first_name, last_name, salary 
FROM employees 
WHERE salary > 100000;

Tested against PostgreSQL 16

Note

“CTAS (Create Table As Select) creates a new table and populates it with the result of a query. It does NOT copy constraints or indexes!