sql 语句运算顺序问题
select (logic1)
from (logic2)
where (logic3)
一条sql 语句 logic1 logic2 logic3 运算顺序是怎样的呢?谢谢谢大家指教。
------解决方案--------------------from --> where --> select
------解决方案--------------------from和where同时-〉select
------解决方案--------------------关注
------解决方案--------------------from,where,select
------解决方案--------------------1. FROM
2. WHERE
3. GROUP BY
4. HAVING
5. SELECT
6. ORDER BY
--------
www.vicmiao.com
努力就有美好时光!
------解决方案--------------------WangZWang(先来) ( ) 信誉:100 Blog 2007-03-13 17:21:01 得分: 0
from --> where --> select
------解决方案--------------------from -> where -> group by -> having -> select -> order by
------解决方案--------------------1,肯定先是查询依据撒
from
2,where
3,group by
having
5,select
6,最后排序
order by
------解决方案--------------------1. FROM
2. WHERE
3. GROUP BY
4. HAVING
5. SELECT
6. ORDER BY
这个不错