首页 > 试题广场 >

对于满足SQL92标准的SQL语句:SELECT foo,c

[不定项选择题]
【单选】对于满足SQL92标准的SQL语句:SELECT foo,count(foo) FROM pokes WHERE foo>10 GROUP BY foo HAVING ORDER BY foo,其执行的顺序应该为()
  • FROM->WHERE->GROUP BY->HAVING->SELECT->ORDER BY
  • FROM->GROUP BY->WHERE->HAVING->SELECT->ORDER BY
  • FROM->WHERE->GROUP BY->HAVING->ORDER BY->SELECT
  • FROM->WHERE->ORDER BY->GROUP BY->HAVING->SELECT
sql执行顺序 
(1)from 
(3) join 
(2) on 
(4) where 
(5)group by(开始使用select中的别名,后面的语句中都可以使用)
(6) avg,sum.... 
(7)having 
(8) select 
(9) distinct 
(10) order by 
发表于 2019-08-24 09:24:31 回复(0)
    A,SQL的执行顺序是 from ,where,group by ,having,select ,order by ,limit
发表于 2019-07-12 13:15:30 回复(0)
A
发表于 2018-09-26 15:07:19 回复(0)