- A subquery in the FROM clause, not created using
CREATE VIEW - Temporary and used within the same SQL statement.
- Inline views are utilized for writing complex SQL queries without join and subqueries operations. This is called a temporary table because a duplicate copy of the data returned by the stored subquery wasn't stored in the database.
SELECT *
FROM (SELECT emp_id, salary FROM employees WHERE salary > 50000) high_earners;
333 99999.56
