SQL View is an imaginary view table based on information retrieved using a select query.
Suppose a user wants to create an imaginary result set that includes records from one or more tables. Then he can create a view using a select query included. And access just using a simple small query.
The syntax for view creation is-
CREATE VIEW view_name AS
An example for view creation is-
CREATE VIEW usersalary_view AS
FROM employees as e
job_history as jh
WHERE e.employee_id = jh.employee_id;