0 votes
1 view
in SQL by (41.9k points)

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

1 Answer

0 votes
by (99.4k 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
1 answer
0 votes
1 answer
asked 5 days ago in SQL by dev_sk2311 (13.3k points)
0 votes
1 answer
0 votes
1 answer
Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...