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 |
What are the assembly entry points?
How many languages are supported by .net?
What are Major Feature of VB.NET Over C#.NET
what is the dif b/w panel and groupbox.
Can you please explain the difference between authentication and authorization?
Explain how does the xmlserializer work?
what are the difference between An input box and Message box ..?
Explain the advantages of migrating to vb.net?
Name and explain some of the exclusive features which are present in vb?
What is writeline in vb.net?
What is tracing?
Explain clr?