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 how to store decimal data in .net?

1142

Explain about the keyword must inherit?

940

What is the difference between convert.tostring and i.tostring method?

934

What is the ruby interface generator?

992

What is the difference between static or dynamic assemblies?

973

Explain the advantage of option strict on?

882

What is option strict?

972

What are the advantages of an assembly?

1019

What does assert() method do In VB.NET

940

What is early binding?

897

How to run a dos command in vb.net?

988

How many ways the function can return values?

963

Explain the difference between import system.data.sqlclient and system.data.oledb?

960

What is the class that allows an element to be accessed using unique key?

1054

Is vb.net a programming language?

935