mysql查询男生基本情况_实验四 数据库查询--2

1、  查询“王林”的基本情况和所工作的部门名称；

Use yggl

Select name,sex,address,departmentname

From employees,departments

Where employees.departmentid=departmentname.departmentid

And name=’王林’;

2、  查询财务部、研发部、市场部的员工信息(要求使用三种语法分别实现)；

(1)    Select *

From employees,salary,departments

Where employees.departmentid=departmentname.departmentid

And employees.employeeid=salary.employeeid

And (departments.departmentname=’研发部’

Or departments.departmentname=’财务部’

Or departments.departmentname=’市场部’);

(2)

Select *

From employees  join  departments

on employees.departmentid=departmentname.departmentid

where  departments.departmentname=’研发部’

Or departments.departmentname=’财务部’

Or departments.departmentname=’市场部’;

(3) Select *

From employees  join  departments

Using (departmentid)

where  departments.departmentname=’研发部’

Or departments.departmentname=’财务部’

Or departments.departmentname=’市场部’;

本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！