6. What are the different views required to work with a table?
Answers
Answered by
0
Answer:
Types of Views
Complex View: A view based on multiple tables, which contain GROUP BY clause and functions. Inline View: A view based on a subquery in FROM Clause, that subquery creates a temporary table and simplifies the complex query. Materialized View: A view that stores the definition as well as data.
Answered by
0
Explanation:
Views are a special version of tables in SQL. They provide a virtual table environment for various complex operations. You can select data from multiple tables, or you can select specific data based on certain criteria in views.
Similar questions