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

How many languages are supported by .net?

0 Answers  


What is the difference between convert.tostring and .tostring() method?

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 please any say na what accuatly would be happend

4 Answers   Infosys,


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

0 Answers  


What is the difference between datagrid and gridview?

0 Answers  






What is portable executable?

0 Answers  


What is option strict?

0 Answers  


Can you please explain the difference between dataset and datareader?

0 Answers  


what is difference between namespace and assembly?

0 Answers  


How do you rate yourself in .NET ?

3 Answers   Infosys, Seneca Global,


hello friends.. when i deployment my project in the client machine that is successful but whenever i try to run my project using .exe file then it gives me error "<filename>.exe is not a valid win32 application." what i do somebody halp me pls

1 Answers  


How does you get record no from 5 to 15 from a dataset of 100 records?

3 Answers   ABC,


Categories