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

Explain manifest?

502


Explain the difference between namespace and assembly?

518


What are the two main parts of .net?

575


What is the difference between convert.tostring and i.tostring method?

561


How to send xml file on server using http protocol?

544






What is the purpose of an Assembly?

610


How to create a constant in vb.net?

605


Explain enumerator?

528


How to achieve Polymorphism in VB.Net?

626


What is the difference between datagrid and gridview?

522


What is trace in vb.net?

591


What is DLL HELL in VB.NET

617


What is break mode? What are the options to step through code?

556


Can you please explain the difference between namespace and assembly?

556


What is internal keyword in .net framework?

634