对于满足SQL92标准的SQL语句: select foo,count(foo)from pokes where foo>10group by foo having count (*)>5 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
答案解析:有
微信扫一扫手机做题