MySQL---自查询

　　二/子查询

#子查询
SELECT * FROM (SELECT * FROM department)t1;
#查询员工表比张三工资高的员工
SELECT * FROM staff where salary>(SELECT DISTINCT salary FROM staff where name='张三')