What is View in SQL and what is the use of it?

Question 1

Question 2

A View can be defined as a virtual table that contains rows and columns with fields from one or more tables.

Syntax:

CREATE VIEW view_name AS

SELECT column_name(s)

FROM table_name

WHERE condition

rajeshsharma · Answer 1 · 2020-11-26T06:15:02+0000

A View can be defined as a virtual table that contains rows and columns with fields from one or more tables.

Syntax:

CREATE VIEW view_name AS

SELECT column_name(s)

FROM table_name

WHERE condition

What is View in SQL and what is the use of it?

Please log in or register to answer this question.

1 Answer