张云春《数据库原理与实用技术》Chapter 7 Integrity,Views,Security,and Catalogs.pptVIP

SQL Language－视图 Create View Example 3：Query every student’s course count and average grade of optional courses Create View S_grade(Sno, C_num, AVG_grade) AS Select Sno, COUNT(Cno), AVG(grade) From SC Where grade is NOT NULL Group by Sno * 7.2 Creating Views Create Views When the Create View statement is executed, no data is retrieved or stored. Instead, the definition of the view is placed in the system catalogs as a distinct object of the database. Example 7.2.2 * View Resolution 7.2 Creating Views Create Views It is extremely important to realize that a view is a window on the dat