以下短句中哪一个是用于分组统计后结果的条件筛选的()。
A: WHERE
B: GROUP
C: HAVING
D: ORDER
A: WHERE
B: GROUP
C: HAVING
D: ORDER
举一反三
- SELECT-SQL语句中,()子句可以指定分组结果的筛选条件。 A: GROUP BY B: HAVING C: WHERE D: ORDER BY
- 在SELECT语句中,下列( )子句用于对分组统计后条件的判断。 A: WHERE B: HAVING C: GROUP BY D: ORDER BY
- 在SELECT语句中,下列子句用于对分组结果进一步设置条件的子句是( ) A: ORDER BY B: GROUP BY C: HAVING D: WHERE
- 在SQL查询语句中以下正确的子句顺序是? A: WHERE --- GROUP BY --- HAVING --- ORDER BY B: GROUP BY --- HAVING --- ORDER BY --- WHERE C: WHERE --- HAVING --- GROUP BY --- ORDER BY D: GROUP BY --- ORDER BY --- HAVING --- WHERE
- 在select语句中,从GROUP BY分组的结果集中再次用条件表达式进行筛选的子句是( ) A: FROM B: ORDER BY C: HAVING D: WHERE