Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in SQL by (55.6k points)

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

1 Answer

0 votes
by (119k points)

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:

Related questions

0 votes
2 answers
0 votes
4 answers
asked Mar 14, 2021 in SQL by dev_sk2311 (45k points)
0 votes
1 answer
0 votes
1 answer
asked Oct 19, 2020 in SQL by dev_sk2311 (45k points)
0 votes
2 answers

31k questions

32.8k answers

501 comments

693 users

Browse Categories

...