What is the purpose of creating views in SQL?

Question

Can anyone tell me what is the purpose of creating views in SQL?

Answer 1

The view is a virtual table based on the result of the SELECT statement. Views are used to limit the visibility of data of the table to just those specific tasks. Also, the view is used for combining the data from multiple tables into a logical table. Views can be used to aggregate rows (using GROUP BY and HAVING) of a table with better detail. The view is used to summarize the data from multiple tables so that views can be used to generate reports.  

If you are interested in SQL, then register for this SQL Course by Intellipaat that offers instructor-led training, certification, and job assistance.

Also, watch this video on SQL to understand more: