Introduce some database commonly used statement, and some actual system commonly used statements.

企业人事数据库
企业员工信息数据库
..................\01.查询employees表中所有数据.sql
..................\02.查询employees表中所有数据(标题用汉语）.sql
..................\03.查询depatments表中所有数据.sql
..................\04.查询employees表中所有数据(用departments中的名称).sql
..................\05.按部门号顺序查询employees表中所有数据.sql
..................\06.查询employees表工资超过2000的员工.sql
..................\07.查询employees表工资超过1500的开发部员工.sql
..................\08.查询employees表姓王的员工.sql
..................\09.查询employees表名字只有两个字的员工.sql
..................\10.查询employees表60年代出生的员工.sql
..................\11.查询employees表中未添出生日期的员工.sql
..................\12.查询开发部员工的工资总和.sql
..................\13.查询不属于开发部员工的基本信息.sql
..................\14.显示工资最高的三位员工信息.sql
..................\15.年龄最大的三位员工.sql
..................\16.找出工资介于2000到3000的员工.sql
..................\17.找出所有在memo字段中含有”经理“两字的员工.sql
..................\18.工资最高最低和平均工资.sql
..................\19.查询employees表中各部门的人数.sql
..................\20.查询工资高于3000的员工人数.sql
..................\21.查询各部门的平均工资，排序.sql
..................\22.查询employees表添加一名员工.sql
..................\23.工资为空则工资定为600.sql
..................\24.工资低于1500则工资涨为200.sql
..................\25.将开发部员工的工资上调10%.sql
..................\26.删除所有年龄大于50的员工数据.sql
..................\27.删除所有销售部的员工数据.sql
..................\28.删除所有员工的数据.sql
..................\my_db_data.mdf
..................\my_db_log.ldf
..................\为employees表添加外键.sql
..................\企业员工信息数据库
..................\修改departments表.sql
..................\修改employees表.sql
..................\修改数据库.sql
..................\创建departments表.sql
..................\创建employees表.sql
..................\创建tmp表.sql
..................\删除数据库.sql
..................\新建数据库.sql
企业员工信息查询
................\01.查询employees表中所有数据.sql
................\02.查询employees表中所有数据(标题用汉语）.sql
................\03.查询depatments表中所有数据.sql
................\04.查询employees表中所有数据(用departments中的名称).sql
................\05.按部门号顺序查询employees表中所有数据.sql
................\06.查询employees表工资超过2000的员工.sql
................\07.查询employees表工资超过1500的开发部员工.sql
................\08.查询employees表姓王的员工.sql
................\09.查询employees表名字只有两个字的员工.sql
................\10.查询employees表60年代出生的员工.sql
................\11.查询employees表中未添出生日期的员工.sql
................\12.查询开发部员工的工资总和.sql
................\13.查询不属于开发部员工的基本信息.sql
................\14.显示工资最高的三位员工信息.sql
................\15.年龄最大的三位员工.sql
................\16.找出工资介于2000到3000的员工.sql
................\17.找出所有在memo字段中含有”经理“两字的员工.sql
................\18.工资最高最低和平均工资.sql
................\19.查询employees表中各部门的人数.sql
................\20.查询工资高于3000的员工人数.sql
................\21.查询各部门的平均工资，排序.sql
................\22.查询employees表添加一名员工.sql
................\23.工资为空则工资定为600.sql
................\24.工资低于1500则工资涨为200.sql
................\25.将开发部员工的工资上调10%.sql
................\26.删除所有年龄大于50的员工数据.sql
................\27.删除所有销售部的员工数据.sql
................\28.删除所有员工的数据.sql
................\为employees表添加外键.sql
................\企业员工信息数据库
................\修改departments表.sql
................\修改employees表.sql
................\修改数据库.sql
................\创建departments表.sql
................\创建employees表.sql
................\创建tmp表.sql
................\删除数据库.sql
................\新建数据库.sql
教学管理数据库
..............\查询语句
..............\........\3.12.1选课表中插入一条记录.sql
..............\........\3.12.2检索所授每门课程平均成绩大于80分的教师姓

• We are an exchange download platform that only provides communication channels. The downloaded content comes from the internet. Except for download issues, please Google on your own.
• The downloaded content is provided for members to upload. If it unintentionally infringes on your copyright, please contact us.
• Please use Winrar for decompression tools
• If download fail, Try it againg or Feedback to us.
• If downloaded content did not match the introduction, Feedback to us，Confirm and will be refund.
• Before downloading, you can inquire through the uploaded person information

Nothing．