how to create views in sql with syntax and example

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which class allows an element to be accessed using unique key?

523


What is the advantage of using system.text.stringbuilder over system.string?

618


source code for how to login a vb.net application ?

599


What is tracing?

617


Explain public assembly?

560






Which classes a dll can contain?

535


Explain global assembly cache (gac)?

729


What is the source code for display the picture in button click event?

715


Explain nested classes?

561


Before in my vb app I would just load the icons from dll. How can I load the icons provided by .net dynamically?

525


What is datatype conversion?

552


What is the difference between custom control and user control?

557


What are the advantages of vb.net and c#?

643


Name the two main parts of .net?

529


Explain about the performance of visual basic?

595