What is the special use of creating "view " in sql we can use select column name(s) table name

Answer 1

If I understand it right, you can use a view as if it were a table after creating it. The database only stores the query, no actual tables are created which saves a lot of storage. Compared to an actual table it automatically "updates" itself.

Why is it sometimes better than a simple query? If you use a specific query a lot, you can improve performance with a view and it simplifies the queries in your ui so that you don't need to nest queries as much.

Hth.

Answer 2

Views can represent a subset of the data contained in a table. Consequently, a view can limit the degree of exposure of the underlying tables to the outer world: a given user may have permission to query the view, while denied access to the rest of the base table