how to create views in sql with syntax and example
Answers were Sorted based on User's Feedback
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 |
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 |
Answer / jayesh patel
CREATE VIEW <View Name> AS <Query Goes here>
Is This Answer Correct ? | 5 Yes | 1 No |
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 |
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 |
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
What is the Advantage of vb.net over vb
What is the difference between system.applicationexception class and system.systemexception?
What is meant by jagged arrays?
What is sealed class?
What is DLL HELL in VB.NET
What are the various open source tool available for VB.NET?
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
What is the strong name in .net assembly?
In vb.net how to connect crystal report?
give me code for selecting itemcode and correspondin vendor details wll displays in the gridview?
Did vb6 support multi-threading ?