要将数据进行分组查询,则可以使用()子句。
A: order by
B: distinct
C: group by
D: having
A: order by
B: distinct
C: group by
D: having
举一反三
- ________子句用于对查询结果进行分组。 A: ORDER BY B: GROUP BY C: HAVING D: WHERE
- 如果要对GROUP分组查询后的数据进行筛选,应使用的子句是( ) A: WHERE B: HAVING C: ORDER BY D: 以上都不对
- SQL使用___________子句将查询结果按某一列或多列的值分组,值相等的为一组。 A: order by B: distinct C: having D: group by
- 利用GROUP BY进行分组查询时,用于筛选满足条件的组,则应使用( )短语。 A: ORDER BY B: HAVING C: DISTINCT D: WHERE
- SQL分组查询时,使用( )子句可以对查询结果按照某一列的值分组。 A: GROUP BY B: ORDER BY C: WHERE D: HAVING