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

What is the difference between .dll extension and .exe extension files?

1053

What are jagged arrays ?

982

What is the significance of delegates?

901

Why do you need Lock in Visual Basic?

1063

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

933

How many classes a dll can contain?

952

What are the differences between c# and visual basic.net?

992

Write a VB.Net console program to check whether a number is perfect or not.

7719

What is the strong name in .net assembly?

961

How do you define a read only property in a class module?

885

What is pre-jit?

983

Explain the difference between vb 6 and vb.net?

940

Can you please explain the difference between int and int32?

1011

Tell us how many languages are supported by .net?

889

Can you please explain the difference between vb and vb.net?

859