DQL 执行顺序:

验证1:
SELECT name,age myAge from emp where myAge > 15 order by age asc;
执行失败:

select 对 age 起别名,但是where 子句 识别不到age的别名
SELECT name,age myAge from emp where age > 15 order by myAge asc;
执行成功:

order by 子句可以识别到select 子句 age的别名,说明 select 的执行顺序在 where 子句 后 order by 子句前