create view <Viewname> as select a as A,b as B,c as C from <tab

how to create views in sql with syntax and example

Question Posted / abhinandan

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

Please Help Members By Posting Answers For Below Questions

Explain about branching logic control in vb.net?

945

What is trace in vb.net?

1016

What is the feature which is common to all .net languages?

921

What are the difference between structure and class?

1174

How many classes a dll can contain?

980

Can you please explain the difference between namespace and assembly?

1049

Explain the services provided by common language infrastructure.

1201

How to store decimal data in .net?

1098

How to create a constant in vb.net?

1169

What is the maximum size of the textbox?

993

difference between checkbox vs radiobutton??

2986

What is break mode? What are the options to step through code?

1055

What are the different types of Lock available in Visual Basic?

1099

Explain the advantages of migrating to vb.net?

1023

What is code access security?

1197