Mysql数据库_DML_子查询.sql

/*
//子查询
*/


#查询工资比Allen高的员工
select sal from tb_emp where ename = '艾伦';
select * from tb_emp where sal > 1600;


# 或者
select *
from tb_emp
where sal > (
select tb_emp
where ename = '艾伦'
);