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

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

556

Explain the difference between dispose and finalize()?

561

What is multiple form in vb?

461

What is the maximum size of the textbox?

537

Explain the services provided by common language infrastructure.

726

Explain redim keyword?

554

Is vb.net a programming language?

543

Which is the base class for all the classes in .net framework?

571

Explain about Visual basic.NET culture?

599

How do you call a stored procedure in Visual Basic?

587

What are the difference between dispose(), close(), exit(), end()? When do we use them?

541

what is difference between namespace and assembly?

539

difference between checkbox vs radiobutton??

2497

Explain internal keyword in .net framework?

575

Is it necessary to have SQL server installed in your computer in order to create a service based database in vb.net?

1870