单选题:SQL 语句执行顺序
对于 SQL 语句:SELECT foo, count(foo) FROM pokes WHERE foo >10 GROUP BY foo HAVING count(foo) >3 ORDER BY foo,正确执行顺序为:
A.FROM->WHERE->GROUP BY->HAVING->SELECT->ORDER BY
B.FROM->GROUP BY->WHERE->HAVING->SELECT->ORDER BY
C.FROM->WHERE->GROUP BY->HAVING->ORDER BY->SELECT
D.FROM->WHERE->ORDER BY->GROUP BY->HAVING->SELECT
答案:A
A.FROM->WHERE->GROUP BY->HAVING->SELECT->ORDER BY
B.FROM->GROUP BY->WHERE->HAVING->SELECT->ORDER BY
C.FROM->WHERE->GROUP BY->HAVING->ORDER BY->SELECT
D.FROM->WHERE->ORDER BY->GROUP BY->HAVING->SELECT
答案:A