- 1Qt实现多通道串口示波器(附完整源码)_使用qt多通道波形显示
- 2C# 中的CSV文件读写
- 32019年天猫商家如何通过积分运营来达到用户运营的效果？
- 4Java(94)枚举复习_sm4-gcm java
- 5VMware worksation 17 简易安装Centos8.2、Redhat8.2、Ubuntu16.04
- 6MySQL索引底层实现原理（B树和B+树）_mysql b树和b+树 原理
- 7爆火的 ChatGPT 太强了！写代码、改 bug，网友：可取代 Stack Overflow 了
- 8安卓高版本手机(MIUI 13 Android12)安装Fiddler证书无法抓取HTTPS问题解决方法_fiddler在android13手机证书下载失败
- 9Java 工具库Hutool_hutools maven地址
- 10flask教程8：模板_flask 模板
mysql列查询_mysql 列子查询
赞
踩
#案例：返回location_id是1400或1700的部门中的所有员工
SELECT last_name
FROM employees
WHERE department_id IN(
SELECT DISTINCT department_id
FROM departments
WHERE location_id IN (1400,1700)
);
#案例：返回其他工种中比job_id为'IT_PROG'部门任一工资低的员工的员工号、姓名、job_id和salary
SELECT DISTINCT employee_id,last_name,job_id,salary
FROM employees
WHERE salary
SELECT DISTINCT salary
FROM employees
WHERE job_id='IT_PROG'
) AND job_id <>'IT_PROG' ;
或者
SELECT DISTINCT employee_id,last_name,job_id,salary
FROM employees
WHERE salary
SELECT DISTINCT MAX(salary)
FROM employees
WHERE job_id='IT_PROG'
) AND job_id <>'IT_PROG' ;
#案例：返回其他工种中比job_id为'IT_PROG'部门所有工资低的员工的员工号、姓名、job_id和salary
SELECT DISTINCT employee_id,last_name,job_id,salary
FROM employees
WHERE salary
SELECT DISTINCT salary
FROM employees
WHERE job_id='IT_PROG'
) AND job_id <>'IT_PROG' ;
或者
SELECT DISTINCT employee_id,last_name,job_id,salary
FROM employees
WHERE salary
SELECT DISTINCT MIN(salary)
FROM employees
WHERE job_id='IT_PROG'
) AND job_id <>'IT_PROG' ;
