Views
In SQL, a view is a virtual table based on the result-set of an SQL statement. It contains rows and columns, just like a real table. The fields in a view are fields from one or more real tables in the database.
We just need to type
CREATE VIEW <viewName> AS
and then the queryCREATE VIEW employee_view AS