What is a view in SQL?

Last updated 2 years, 6 months ago | 753 views 75     5

Tags:- SQL MySQL

SQL | View

View in SQL is a kind of virtual table. It does not physical exists in our database but have rows and column as there we have in a real database table. we can create a view by selecting fields from one of the tables present in the database. A View can have all the rows of a table or specific rows based on certain conditions.

 

The CREATE VIEW statement of SQL is used for creating Views.

Syntax:

CREATE VIEW view_name AS
SELECT column1, column2, ...
FROM table_name
WHERE condition;

view_name: Name for the View
table_name: Name of the table
condition: Condition to select rows

Example:

CREATE VIEW Employee AS
SELECT ID, NAME, SALARY
FROM employee
WHERE salary < 10000;
    +----+----------+----------+
    | ID | NAME     | SALARY   |
    +----+----------+----------+
    |  1 | Kamal    |  3000.00 |
    |  2 | Roshan   |  3000.00 |
    |  3 | Shyam    |  2000.00 |
    |  4 | Sagar    |  6500.00 |
    |  5 | Komal    |  8500.00 |
    +----+----------+----------+