how to create views in sql with syntax and example

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we use Vb.Net and C# language simultaneously in one .Net application?

556


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

537


How to execute VB.NET PROJECTS,VB6.0 PROJECTS AND write their test cases.Need Reply Urgently

1991


What does assert() method do In VB.NET

527


Describe about visual basic.net?

551






What do you mean by Redim in VB.NET?

665


What is the role of new keyword?

619


What is the difference between c# and vb.net?

555


write a program to develop a graphic user interface application of marks book with students names and their names.the program should show the following options main menu,add student details,display student details,maximum mark and minimum mark.

1172


What is a static variable?

554


What is branching logic control in VB.NET?

566


What is code security?

520


Why do we use byref keyword in vb.net?

592


Name the two main parts of .net?

518


Explain convert.tostring and i.tostring method?

519