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

How to achieve Polymorphism in VB.Net?

1075

What is pre-jit?

1047

How a base class method is hidden?

1097

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

1102

How many classes a dll can contain?

988

Explain how to achieve polymorphism in vb.net?

949

Explain about the ruby interface generator?

988

What is redim keyword?

1005

Explain convert.tostrin?

1062

Which classes a dll can contain?

992

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

1124

Name some of the keywords used in vb.net?

1026

Can you please explain the difference between value and reference types?

934

What are the advantages of an assembly?

1074

What is the use of errorprovider control?

1011