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