How to create a view in SQL

You can create a view in SQL by following the following syntax.

CREATE VIEW view_name AS `sql-select-query`;

For Example

CREATE VIEW view_name AS SELECT * from table_name;