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

how to deploy vb.net with key and evaluation time? any one can help me?

2222

What is pre-jit?

1051

Is vb.net a programming language?

993

What is branching logic control in VB.NET?

987

What is visual basic.net culture?

1044

What is the difference between compiler and interpreter?

1035

How to retrieve images in sql server database through vb.net?

985

What is the differnce between managed code and unmanaged code?

995

what is difference between web.config and machine.config and where it will be ?

946

What is the difference between vb 6 and vb.net?

1119

What is the size of .net object?

1048

Explain the difference between thread and process?

1002

Why do we use byref keyword in vb.net?

1065

What are the objects in asp.net?

1154

What are the two main parts of .net?

1005