What is the difference between view and table

Answer 1

View doesn't hold any data. It only shows data from tables.

Answer 2

A table contains data, a view is just a SELECT statement which has been saved in the database (more or less, depending on your database).

The advantage of a view is that it can join data from several tables thus creating a new view of it. Say you have a database with salaries and you need to do some complex statistical queries on it.

Instead of sending the complex query to the database all the time, you can save the query as a view and then SELECT * FROM view

Answer 3

1.A table is an object of a database which is used to hold data that are used in reports and applications while a view is also a database object which is used as a table and query that can be linked to other tables.
2.A table is designed with a limited number of columns and an unlimited number of rows while a view is designed as a virtual table that is extracted from a database.
3.A view can incorporate several tables into one virtual table while several tables are needed to store linked data and records.
4.A view is used to query certain data contained in several different tables while a table holds basic user data and holds instances of a defined object.
5.Frequently queried data can be accessed in a view, and changing the data in the database also changes the data shown in the view which is not the case in a table.