第1个回答 2010-07-06
create view filename
[fields1,fields2……]
as
SQL语句
第2个回答 2010-07-07
4.视图的创建
CREATE VIEW STUDENT_SCORE
AS SELECT student.stu_no, AVG(selectcourse.grade)
FROM student, selectcourse
WHERE student.stu_no = selectcourse.stu_no
GROUP BY student.stu_no
HAVING AVG(selectcourse.grade) >= 100;
第3个回答 2010-07-19
create view as
select 查询语句
第4个回答 2010-07-06
示例
A. 使用简单的 CREATE VIEW
下例创建具有简单 SELECT 语句的视图。当需要频繁地查询列的某种组合时,简单视图非常有用。
USE pubs
IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS
WHERE TABLE_NAME = 'titles_view')
DROP VIEW titles_view
GO
CREATE VIEW titles_view
AS
SELECT title, type, price, pubdate
FROM titles
GO