Querying a VIEW

Query a view like a table.

After creating a VIEW you query it with SELECT like a regular table.

SELECT * FROM active_customers;

This query returns active customers.

All columns are selected from active_customers.

Querying a VIEW — details

When queried, the underlying query runs. You can add WHERE and ORDER BY.

For example, SELECT * FROM active_customers WHERE city = 'İzmir' ORDER BY name further filters and sorts the view's result.

Select all columns from the active_customers VIEW.

Show example solution

SELECT * FROM active_customers;

Add FROM

SELECT * ____ active_customers;

Show answer

SELECT * FROM active_customers;

Next lesson: DROP VIEW