UTpaper

Free mock tests & test series

Question 153Asked in DSSSB PGT Computer Science (Technical), 11 Jul 2021

In Structured Query Language, what is the GROUP BY clause?

  1. AIt groups the table with same name in the database
  2. BIt groups the rows together that contain the same values in a specific column
  3. CIt combines data from two tables on specific conditions
  4. DIt groups the columns together that contains the same valuesin a specific rows
Show answerHide answer

Correct answer: (B) It groups the rows together that contain the same values in a specific column

Explanation

GROUP BY puts rows with the same values in the given column(s) into groups, usually for aggregates like SUM or COUNT.

From DSSSB PGT Computer Science PYQ (Technical), 11 Jul 2021

This is question 153 of DSSSB PGT Computer Science PYQ (Technical), 11 Jul 2021. See all questions of this paper with answers, or attempt the paper as a timed online test to get your score and all-India rank.