Back

Explore Courses Blog Tutorials Interview Questions
0 votes
1 view
in Blockchain by (119k points)

Can anyone explain how to create a view in SQL?

1 Answer

0 votes
by (55.6k points)
edited by

In SQL, the view is a virtual table that is stored in a database based on the result set of the SELECT statement. We can create a view using the CREATE VIEW statement. Here is the syntax to create a view in SQL server:

CREATE VIEW view_name as

SELECT column_name

FROM table_name

WHERE condition(s);

You can check out this SQL Tutorial to understand more about the view and using views.

Related questions

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
asked May 7, 2020 in SQL by Praveen_1998 (119k points)

Browse Categories

...