SELECT-SQL语句中,()子句可以指定分组结果的筛选条件。
A: GROUP BY
B: HAVING
C: WHERE
D: ORDER BY
A: GROUP BY
B: HAVING
C: WHERE
D: ORDER BY
举一反三
- SELECT语句中,使用________子句可按指定列的值分组。( ) A: WHERE B: HAVING C: GROUP BY D: ORDER BY
- 在select语句中,从GROUP BY分组的结果集中再次用条件表达式进行筛选的子句是( ) A: FROM B: ORDER BY C: HAVING D: WHERE
- 在SELECT语句中,下列子句用于对分组结果进一步设置条件的子句是( ) A: ORDER BY B: GROUP BY C: HAVING D: WHERE
- SELECT语句中,SELECT语句中,使用GROUP BY子句可按指定列的值分组,同时使用( )可提取满足条件的组。 A: WHERE B: HAVING C: GROUP BY D: ORDER BY
- SQL语言的Select语句中,用于分组的语句为()。 A: where B: group by C: order by D: having