```sql -- (select * from employee) a 查询employee的结果临时存储为表a -- 然后再对表a查询 select * from (select * from employee) a where name='Will'; ```