Question: sql views are constructed from select statements?
Answer: SQL views are constructed from SELECT statements. According to the SQL-92, statements used to construct views cannot contain the WHERE clause. The SQL command SELECT is used to retrieve view instances. SQL views can be used to hide columns.