Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

How to connect crystal report in vb.net ?

889


What is the diff between vb mdi form and .net mdi form?

957


What is the difference between .dll extension and .exe extension files?

1049


What are the advantages of an assembly?

1015


What is the advantages of VB.NET?

981


Explain convert.tostrin?

989


What is code access security?

1145


Explain the difference between namespace and assembly?

937


List the two main parts of .net?

1023


What do you mean by serialization and deserialization?

885


What are the objects in asp.net?

1071


Can you please explain the difference between thread and process?

920


What are the different types of applications supported in .net (or) .net framework?

880


What is the difference between manifest and metadata?

983


Explain code security?

870