how to create views in sql with syntax and example
Answer Posted / 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 |
Post New Answer View All Answers
What is an application domain? how they get created?
How to achieve Polymorphism in VB.Net?
What is strong name in .net assembly?
Is vb net a scripting language?
Can you please explain the difference between thread and process?
What does assert() method do In VB.NET
Observations between vb.net and vc#.net?
Explain about branching logic control in vb.net?
Write a program to find all text files in a logical drive and return the count of the number of files?
How do you define a read only property in a class module?
Explain about garbage collection?
What is portable executable?
What are the assembly entry points?
i am attending to US consulate i kept my projects on vb.net ,please help me what questions will be ask on vb.net in us consulate
Explain about jagged arrarys ?