- Learn MySQL
- MySQL - Home
- MySQL - Introduction
- MySQL - Installation
- MySQL - Administration
- MySQL - PHP Syntax
- MySQL - Connection
- MySQL - Create Database
- MySQL - Drop Database
- MySQL - Select Database
- MySQL - Data Types
- MySQL - Create Tables
- MySQL - Drop Tables
- MySQL - Insert Query
- MySQL - Select Query
- MySQL - Where Clause
- MySQL - Update Query
- MySQL - Delete Query
- MySQL - Like Clause
- MySQL - Sorting Results
- MySQL - Using Join
- MySQL - NULL Values
- MySQL - Regexps
- MySQL - Transactions
- MySQL - Alter Command
- MySQL - Indexes
- MySQL - Temporary Tables
- MySQL - Clone Tables
- MySQL - Database Info
- MySQL - Using Sequences
- MySQL - Handling Duplicates
- MySQL - SQL Injection
- MySQL - Database Export
- MySQL - Database Import
Difference between Simple and Complex View in SQL
Before discussing on Simple and complex, first we should know what is View. A View is the logical virtual table created from one or more tables which can be primarily used to fetch the columns from one or more different tables at a time. On the basis of tables involved in the view we can distinguish between Simple and Complex View in SQL.
Following are the important differences between Simple and Complex View.
| Sr. No. | Key | Simple View | Complex View |
|---|---|---|---|
| 1 | Definition | Simple View in SQL is the view created by involving only single table. In other words we can say that there is only one base table in case of Simple View in SQL. | On other hand, Complex View is created by involving more than one table i.e., multiple tables get projected in Complex view. |
| 2 | Associations | In case of Simple View as only one table is in context hence no major associations need to be applied in case of this view in SQL. | On other hand in case of Complex View multiple tables are in the context hence general associations need to be applied which includes join conditions, a group by clause, a order by clause. |
| 3 | Group Functions | In Simple View, due to single table we cannot use group functions like MAX(), COUNT(), etc. | On other hand in case of Complex View due to multiple tables we can use various group functions. |
| 4 | Operations allowed | In Simple View, DML operations could easily be performed. | However on other hand in case of Complex view DML operations could not always be performed. |
| 5 | Alteration | As mentioned in above point due to DML operations INSERT, DELETE and UPDATE are directly possible. | However on the other hand in case of Complex view, we cannot apply INSERT, DELETE and UPDATE. |
| 6 | NULL columns | In Simple View one cannot include NOT NULL columns from base table. | However on other hand in case of Complex view, NOT NULL columns can be included in complex view. |
- Related Articles
- What is the difference between complex and simple carbohydrates?
- What is the difference between complex and simple machines?
- Explain the difference between a table, view and synonym in SQL
- Difference between SQL and PL/SQL
- Difference Between SQL and T-SQL
- Difference Between View and Materialized View
- Difference between Static SQL and Dynamic SQL
- Difference Between T-SQL and PL-SQL
- Difference between SQL and NoSQL
- Difference between SQL(Structured Query Language) and T-SQL(Transact-SQL).
- Difference between Join and union in SQL
- Difference Between COMMIT and ROLLBACK in SQL
- Difference Between DELETE and DROP in SQL
- Difference between MySQL and SQL Server
- Difference between Oracle and SQL Server
Advertisements