how to create views in sql with syntax and example

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a static class?

586


Explain what observations between vb.net and vc#.net?

554


Explain jit?

546


What is a static variable?

554


What is global assembly cache (gac)?

553






What is the significance of delegates. Where should they be used?

508


what is intermediate language?

606


What is early binding?

522


Explain how to store decimal data in .net?

705


How to connect crystal report in vb.net ?

570


How many languages are supported by .net?

540


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

631


What is tracing?

605


What is the difference between readonly variable and constant variable?

551


Explain about visual basic.net?

654