Difference between View & Temp Table? what is view in sql?

Question

Accepted Answer

Views are virtual tables that display data from one or more tables, while temp tables are temporary tables that store data temporarily.

Views are virtual tables created by a query, while temp tables are physical tables created in the database.
Views do not store data themselves, but display data from underlying tables, while temp tables store data temporarily for a session or transaction.
Views can be used for security purposes by restricting access to certain columns or rows, while temp tables are useful for storing intermediate results during complex queries.
Example: CREATE VIEW vw_employee AS SELECT * FROM employee_table;
Example: CREATE TEMPORARY TABLE temp_table AS SELECT * FROM orders WHERE order_date > '2022-01-01';

Top Decathlon Senior Data Analyst interview questions & answers