Q: What is View? Why should I use it?

A: View is a virtual table. The table does not really exist. View is defined by a SELECT statement, and is a set of specified data. Accessing data through view will simplify query statements and provide some level of authority control.