文件名称: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
本网站为编程资源及源代码搜集、介绍的搜索网站,版权归原作者所有! 粤ICP备11031372号
1999-2046 搜珍网 All Rights Reserved.