SQL分组查询时,使用( )子句可以对查询结果按照某一列的值分组。
A: GROUP BY
B: ORDER BY
C: WHERE
D: HAVING
A: GROUP BY
B: ORDER BY
C: WHERE
D: HAVING
举一反三
- SELECT查询中,要按照某一列的值进行分组查询出结果,所用到的子句是 A: ORDER BY B: GROUP BY C: WHERE D: HAVING
- SQL使用___________子句将查询结果按某一列或多列的值分组,值相等的为一组。 A: order by B: distinct C: having D: group by
- SQL排序查询时,使用( )子句可以对查询结果按照一个或多个列的升序()或降序()排列。 A: GROUP BY B: ORDER BY C: WHERE D: HAVING
- ________子句用于对查询结果进行分组。 A: ORDER BY B: GROUP BY C: HAVING D: WHERE
- 在SQL查询语句中,指出是有条件分组查询的两个子句是( )。 A: Order By和Having B: Order By和Where C: Group By和Where D: Group By和Having