View Creation

Question

CREATE VIEW V AS(SELECT R1.A,R2.B FROM R AS R1, R as R2 WHERE R1.B=R2.A)

Suppose the current contents of relation R

A	B
1	2
2	6
2	5
3	5

 

------------------------------------------------------------------------------------------------------------------------

How to create view? Give some instances of it

Answer 1

• A view just like a real table and a view contain row and column.

• In your query one virtual table is created . And the name of virtual table is v.