你可能感兴趣的试题
HAVING DISTINCT ORDERBY GROUPBY
“连接”选项卡与SQL语句的GROUPBY短语对应 “筛选”选项卡与SQL语句的HAVING短语对应 “排序依据”选项卡与SQL语句的ORDERBY短语对应 “分组依据”选项卡与SQL语句的JOINON短语对应
HAVING必须与ORDERBY短语连用 ASC必须与短语GROUPBY短语连用 ORDER BY短语通常在GROUPBY短语之后 ORDER BY短语必须与GROUPBY短语连用
WHERE FROM SELECT GROUPBY
选择行条件 对查询进行排序 选择列字段 对查询进行分组
ORDERBY GROUPBY HAVING ASC
groupby orderby having limit
distinct where unique groupby
WHERE SELECT FROM GROUPBY
ORDER BY HAVING BY GROUP BY COMPUTE BY
湘公网安备 43130202000226号