how to create views in sql with syntax and example

Answers were Sorted based on User's Feedback



how to create views in sql with syntax and example..

Answer / abhinandan

create view <Viewname> as
select a as A,b as B,c as C
from <tablename>
where <whereclause{optional}> order by A

Is This Answer Correct ?    8 Yes 1 No

how to create views in sql with syntax and example..

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

how to create views in sql with syntax and example..

Answer / jayesh patel

CREATE VIEW <View Name> AS <Query Goes here>

Is This Answer Correct ?    5 Yes 1 No

how to create views in sql with syntax and example..

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

how to create views in sql with syntax and example..

Answer / v.vaithyanarayanan

CREATE VIEW table_name [ ( column_name1,
column_name2, ... ) ]
AS SELECT ...

EX:
CREATE VIEW ViewOfTableA AS SELECT col1 FROM TableA

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More VB.NET Interview Questions

I Am Developing A project where I can send Message from One Computer to Another Computer With The Help Of LAN.Already I Have developed..It is working Fine With The Details Of ..TO,FROM,REF No,DATE,BODY...Now I Want To Add Attachments part in the same projects...How Can I Send Attachment File & How To Send It..I Am Working in VB.Net 2005 With out Any database. Can Any One Help me ??How To Write Code??Plz Send me a copy to my Mail also...I Dont Need Any Software Available in The Internet...Plz refer me The Code in VB.Net maloy.adhikari@in.com

0 Answers  


What is the Advantage of vb.net over vb

0 Answers   Digital GlobalSoft,


What is the difference between system.applicationexception class and system.systemexception?

0 Answers  


What is meant by jagged arrays?

0 Answers  


What is sealed class?

0 Answers  






What is DLL HELL in VB.NET

0 Answers   HCL,


What are the various open source tool available for VB.NET?

0 Answers  


i had attended to infosys interview on 17th april 2010...on .net..3+ experience .. to my knowledge i did well in technical and they asked me to wait for next process ..so i waited for 15 min ..later one person came and said give 7-10 days time for intimation of next process do they keep technical and hr on different day ...or i loose the interview ..am confused yaar what accuatly would be happend

2 Answers  


What is the strong name in .net assembly?

0 Answers  


In vb.net how to connect crystal report?

1 Answers  


give me code for selecting itemcode and correspondin vendor details wll displays in the gridview?

1 Answers  


Did vb6 support multi-threading ?

0 Answers  


Categories