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

Is it necessary to have SQL server installed in your computer in order to create a service based database in vb.net?

2358

Explain the difference between dispose and finalize()?

1098

What is a stream in vb.net?

987

What is stack used for in vb. Net?

930

Why do we use ansi keyword?

980

Which namespace are used for accessing the data?

1232

How many ways the function can return values?

1007

Which properties are used to bind a DataGridView control?

1112

What is code security?

1021

Explain some of the exclusive features which are present in vb?

911

What is the top .net class that everything is derived from?

1054

How vb implements the disconnected architecture as like vb.net?

1006

What is vb.net used for?

935

What is the difference between convert.tostring and .tostring() method?

1014

Can you please explain the difference between thread and process?

978