CREATE VIEW vino (view_name) AS SELECT mark1 (column

how to create views in sql with syntax and example

Question Posted / vinoth

Answer Posted / vinoth

CREATE VIEW vino (view_name)
AS
SELECT mark1 (column_name(s))
FROM stud(table name)
WHERE avg>80 (condition)

Is This Answer Correct ?

5 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can you please explain the difference between thread and process?

914

Compare c# and visual basic.net?

909

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

1067

Explain how to store decimal data in .net?

1124

Explain convert.tostrin?

984

What is jagged array in vb.net?

1034

what is common type system?

847

How to achieve Polymorphism in VB.Net?

1015

What is the ruby interface generator?

979

Explain cls?

955

What is strong name in .net assembly?

919

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

1038

Why should you use delegate?

868

what's ArrayList in .Net (VB.Net or C#).What's the advantageous using ArrayList.

970

What are all the differences between dispose and finalize()?

996