首页 > 试题广场 >

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

[填空题]
对于满足SQL92标准的SQL语句:select foo,count(foo) from pokes where foo>10 group by foo having count(*)>5 order by foo,各关键字(select, from, where, group by, having, order by)的执行顺序应该是1
因为查询的时候是先去找某表from,再在某表里面筛选条件where,然后对筛选完的进行分组group by,分组完就在分组的每一个组进行筛选条件having,然后取出来想要的列select,最后进行排序order by。
发表于 2019-08-30 16:34:32 回复(1)

FROM->WHERE->GROUP BY->HAVING->SELECT->ORDER BY

发表于 2019-07-24 10:43:04 回复(0)
from where group by having select order by
发表于 2022-04-26 11:25:03 回复(0)
1.from  2.where  3.group by  4.having  5.select  6.order by
发表于 2022-04-02 16:19:23 回复(0)
SELECT 
FROM
WHERE
GROUP BY 
HAVING
ORDER BY
发表于 2022-01-28 01:39:26 回复(0)
select> from>where>group by>having> order by
发表于 2021-11-29 22:46:15 回复(0)
from>where>group by>having>select>order by
发表于 2021-11-15 15:23:13 回复(0)
from
on
join
where
group by
having 
select 
order by
limit

发表于 2020-09-04 18:53:28 回复(0)
from >where> group by>haning>select>order by
发表于 2020-07-20 22:51:25 回复(0)
FROM->WHERE->GROUP BY->HAVING->SELECT->ORDER BY
发表于 2019-12-17 10:00:00 回复(0)
 from, where, group by, having,  select,order by
发表于 2019-09-29 21:20:33 回复(0)
编辑于 2019-09-09 20:27:32 回复(0)