Question

what is the command used to define view in SQL??​

Answer 1

Hey!!

✌️ Answer ✌️

The basic CREATE VIEW syntax as follows:

=> CREATE VIEW view_name AS

=> SELECT colum1, colum2...

=> FROM table_name

=> WHERE [condition];

Note: You can include multiple tables in your SELECT statement in a similar way as you use them in a normal SQL SELECT query.