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 / vinoth

CREATE VIEW vino (view_name)
AS
SELECT mark1 (column_name(s))
FROM stud(table name)
WHERE avg>80 (condition)

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why is the xml infoset specification different from the xml dom?

922


Name and explain some of the exclusive features which are present in vb?

956


What is the advantage of using system.text.stringbuilder over system.string?

1137


thak you Mr Govind for replying to my question. My next question is that how to retrieve image stored in an SQL server table and assign it to any image control or picture control using VB.net

2102


What are the assembly entry points?

1024


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

975


Can you please explain the difference between system.string and system.stringbuilder classes?

1051


Why do we use byref keyword in vb.net?

1055


Explain the difference between web.config and machine.config and where it will be ?

926


What is code access security?

1197


Explain the components of common language runtime.

1128


What is an application domain? how they get created?

1022


Explain namespace?

1115


What do you mean by deserialization?

969


What are the advantages of vb.net and c#?

1118