SQL 子查询
来源:互联网 发布:北京特色礼品 知乎 编辑:程序博客网 时间:2024/05/14 14:34
1、单行子查询
--返回job_id与141号员工相同,salary比143
号员工多的员工的姓名、job_id、工资
select last_name,job_id,salary
from employees
where job_id=(
select job_id
from employees
where employees_id=141
)
and salary>(
select salary
from employees
where employees_id=143
)
2、多行子查询
返回其他部门中比job_id为‘IT_PROG’
部门任一工资低的员工的
员工号、姓名、job_id、salary
select employees_id,last_name,
job_id,salary
from employees
where job_id<>'IT_PROG'
//比子查询返回的记录的任一一个小
and salary<any(
select salary
from employees
where job_id='IT_PROG'
)
select employees_id,last_name,
job_id,salary
from employees
where job_id<>'IT_PROG'
//比子查询返回所有记录都小
and salary<all(
select salary
from employees
where job_id='IT_PROG'
)
--返回job_id与141号员工相同,salary比143
号员工多的员工的姓名、job_id、工资
select last_name,job_id,salary
from employees
where job_id=(
select job_id
from employees
where employees_id=141
)
and salary>(
select salary
from employees
where employees_id=143
)
2、多行子查询
返回其他部门中比job_id为‘IT_PROG’
部门任一工资低的员工的
员工号、姓名、job_id、salary
select employees_id,last_name,
job_id,salary
from employees
where job_id<>'IT_PROG'
//比子查询返回的记录的任一一个小
and salary<any(
select salary
from employees
where job_id='IT_PROG'
)
select employees_id,last_name,
job_id,salary
from employees
where job_id<>'IT_PROG'
//比子查询返回所有记录都小
and salary<all(
select salary
from employees
where job_id='IT_PROG'
)
0 0
- sql嵌套子查询
- sql子查询语句
- Sql子查询
- sql子查询语句
- SQL嵌套子查询
- SQL server子查询
- SQL子查询实例
- SQL 基础--> 子查询
- sql with 子查询
- SQL 内联子查询
- sql 子查询
- SQL子查询
- SQL---DML---子查询
- 相关子查询 - SQL
- sql子查询用法
- SQL Server 子查询
- SQL嵌套子查询
- sql 子查询优化
- C++命名规则
- [] == false,和!![] == false结果为什么不一样?探究 == 本质
- scala隐式转换
- SQL Server中的锁类型及用法
- ping 命令
- SQL 子查询
- 浅谈原生js的五个数组迭代方法
- P1198 [JSOI2008]最大数
- testng忽略测试
- Phthon3 数字
- 大话设计模式读书 笔记(六) 工厂方法模式
- Sql Server全字段模糊查询
- Mysql主从配置
- gnuplot 等高线脚本