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 |
How many languages are supported by .net?
What is the difference between convert.tostring and .tostring() method?
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
Explain the difference between web.config and machine.config and where it will be ?
What is the difference between datagrid and gridview?
What is portable executable?
What is option strict?
Can you please explain the difference between dataset and datareader?
what is difference between namespace and assembly?
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
How does you get record no from 5 to 15 from a dataset of 100 records?