• 2022-05-30
    SELECT查询中,要按照某一列的值进行分组查询出结果,所用到的子句是
    A: ORDER BY
    B: GROUP BY
    C: WHERE
    D: HAVING
  • B

    内容

    • 0

      SQL分组查询时,使用( )子句可以对查询结果按照某一列的值分组。 A: GROUP BY B: ORDER BY C: WHERE D: HAVING

    • 1

      在SELECT查询中,要把结果中的行按照某列的值进行排序,所用到的子句是( )。 A: WHERE B: HAVING C: GROUP BY D: ORDER BY

    • 2

      SELECT查询中,要把结果中的行按照某一列的值进行排序,所用到的子句是( )。 A: WHERE B: GROUP BY C: ORDER BY D: SORT BY

    • 3

      ________子句用于对查询结果进行分组。 A: ORDER BY B: GROUP BY C: HAVING D: WHERE

    • 4

      SELECT( )子句用于对查询的结果进行分组。 A: ORDERY BY B: GROUP BY C: HAVING D: WHERE