how to create views in sql with syntax and example

Answer Posted / ranjith reddy

CREATE VIEW view_name AS
SELECT column_name(s)
FROM table_name
WHERE condition

Using Views
CREATE VIEW [Current Product List] AS
SELECT ProductID,ProductName
FROM Products
WHERE Discontinued=No

Is This Answer Correct ?    5 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different variables in vb.net?

702


What are the different types of Lock available in Visual Basic?

839


How do you define a read only property in a class module?

705


Explain some of the exclusive features which are present in vb?

700


described weak typing?

776


What is the difference between manifest and metadata?

731


What is the purpose of objects present in asp.net?

757


What are the assembly entry points?

752


What is difference between metadata and manifest?

800


Which control is an example of an object in vb net?

6679


Explain option strict?

727


What are all the differences between dispose and finalize()?

741


What are the difference between dispose(), close(), exit(), end()?

688


Explain the difference between dispose and finalize()?

764


What are the differences between c# and visual basic.net?

742