日期:2014-05-19  浏览次数:20376 次

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
这个不错