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 |
Explain how to send xml file on server using http protocol?
How do you validate Date by using which validation Control?
What would you do to remove microsoft visual basic name space?
Explain redim keyword?
what is interface and when it is used?
described weak typing?
Can you please explain the difference between system.string and system.stringbuilder classes?
Explain what observations between vb.net and vc#.net?
Can you please explain the difference between value and reference types?
What is the exact defination of object?
code for itemstockgroupwise record?
How would you implement inheritance using vb.net?