文件名称:7.sql
介绍说明－－下载内容均来自于网络，请自行研究使用
数据表的高级查询操作,课程名称：数据库技术
实验名称：数据的高级查询 实验课时：4课时 实验时间：第11周
实验环境：SQL Server 2005
实验目的：
1、掌握左连接、右连接、全接连的查询。
2、掌握带“IN”谓词的子查询。
3、掌握带比较运算符谓词的子查询。
4、掌握带“EXISTS”谓词的子查询。
-Advanced query data tables, course name: the name of the database technology experiment: experimental data of high-level query class: 4 hours of test time: 11 weeks experimental environment: SQL Server 2005 experimental purposes: 1, master left join, right outer joins, the whole series the query. 2, master with " IN" predicate of the subquery. 3, the control sub-queries with comparison predicates. 4, master with " EXISTS" subquery predicate.
实验名称：数据的高级查询 实验课时：4课时 实验时间：第11周
实验环境：SQL Server 2005
实验目的：
1、掌握左连接、右连接、全接连的查询。
2、掌握带“IN”谓词的子查询。
3、掌握带比较运算符谓词的子查询。
4、掌握带“EXISTS”谓词的子查询。
-Advanced query data tables, course name: the name of the database technology experiment: experimental data of high-level query class: 4 hours of test time: 11 weeks experimental environment: SQL Server 2005 experimental purposes: 1, master left join, right outer joins, the whole series the query. 2, master with " IN" predicate of the subquery. 3, the control sub-queries with comparison predicates. 4, master with " EXISTS" subquery predicate.
(系统自动生成,下载前可以参看下载内容)
下载文件列表
7.数据表的高级查询操作.sql