SQL view is a kind of virtual table that has rows and columns as they are in a real database. The view can be accompanied with all the rows of a particular table or selected rows based on a certain condition. In Structured Query Language, a view is a virtual table based on the result-set of an SQL statement.

SQL VIEWS

SQL view contains rows and columns, just like the real table. The fields in the view are fields from one or more real tables in the database. You can add the SQL functions,  WHERE, and  JOIN statements to the view and present data as if that data were coming from a single table.

#sql #sql view