What is view in SQL?
View is a virtual table in SQL that gets the data from SQL Select Statement. You can use JOINS, WHERE clause and some SQL Functions to make data more usefule in view. View has rows and columns same like SQL tables.
Create View Example: Use following syntax to create view:
CREATE view active_customers as SELECT * FROM customer WHERE active = 1;