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

List the types of generations in garbage collector?

848


Why do we use ansi keyword?

921


What is meant by jagged arrays?

972


What is static member?

962


What is redim keyword?

939


Name a feature which is common to all .net languages?

952


What is code security?

950


Can you please explain the difference between thread and process?

914


Explain the advantages of vb.net?

894


How to run a dos command in vb.net?

977


What is vb.net used for?

899


What is the source code for display the picture in button click event?

1096


Explain about rapid application development tool?

899


Explain the difference between thread and process?

919


What are the difference between structure and class?

1062